Posted: 10/1/2007 12:34:03 AM EDT
|
Not sure how much help I'm going to get this late but here goes: I'm working on a Finance project in excel and don't know the function or how to write out the formula for the results I need. I have several columns with the numbers being reduced in the first column by a main column of numbers. What I need for it to do is once the first column hits 0, the numbers in the second column start being reduced by the main column. I know, hard to explain. Hell I'll draw a graph if it'll help. Lemme know what you guys got. Thanks! |
|
I'm slowly starting to get it now. Just using a lot of IF functions. BTW is there a to use multiple IF functions. Where one IF function must be satisfied before the next one? Any special way of writing that? Sorry I'm not very coherent. It is 5:30 here and I've been working on this for 12 hours now |
That's what I was thinking. If the first column is "column A" and the second column is "column B". So write the formula in the column B SUM or whatever the bottom is. The format is: IF(condition, what happens if condition is true, else what happens when condition is false) IF("column A"<=0, SUM of "column B" - "main column, SUM of "column B") You can nest the formulas too. |
Yes, the IF statements are nestable. It would look something like this: IF(A10<=100,IF(A10<=70,"Damn penny pincher","Within budget"),"Over budget") |
Oh wow. Thank you so much it finally makes sense. |