Posted: 1/17/2008 5:08:00 PM EDT
|
What I need Column 1 Gross Income Column 2 Avg gross income/week needed to make X dollars per year Column 3 % difference between column 1 and 2 Column 4 YTD gross income. I want to be able to plug in my gross income in column 1 and have formulas to calculate 2,3 and 4 automatically. Help I suck at Excel. |
You simply make a cell referance that adds each new week to the number above it. Like this: =e1+a2 Then the next E cell would be =(E2+E1)+A3 It doesn't make much sense out of excel though. |
Better way to do this? |
|
I'll take a run at it, since I think I know what you are trying to do. Assumptions: 1) Column 1 = Column A in Excel. 2) The formula is contained in row 1 in Excel 3) The "X dollars per year" variable will be contained in cell B2 OK... A1 is your current weekly gross income B1 formula: =B2/52 C1 formula: =(B1-A1)/B1 D1 formula: =A1*somefuckingdatefunction Gimme a minute on the date function.  Is this kinda what you are looking for? |
|
Use cell referencing in your formulas. For example, you could do =1000*52 to get yearly gross. Using cell referencing allows you to change a value and it will carry through the formulas. It would look something like: =A2*52 This is assuming 52 pay periods. You can toggle the F4 key to lock in a row, column or both if you try to drag the formula. For the ytd formula, look up the DATE function. I hope this is what you are looking for. |
|
Let me see if I understand you. You want col A to be your current weekly gross income? You want col B to be X dollars, or the amount of weekly gross income needed to make Y dollars per year? You want col C to be the % difference between col A and col B? You want col D to be your YTD gross income? Is this correct? |
Yes |
IM me and I will e-mail you my spreadsheet. |
my email is hammered77 at Yahoo dot com
Second one works, just have to modify it a tad bit. I just did not know where to start, thanks for the help! Keep the ideas coming if anyone else is working on it!  The knowledge here amazes me.
|
Got it! Tweak one thing. Does what I need it to do. Thanks for all the help! |