| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Logical Formulas
Is there anyone that can help? Please advise.
"debinnyc" wrote: Still not working. I copied the formula exactly to the spreadsheet, and filled in the appropriate cell locations. The formula does not have any errors, but the result of the formula shows a negative value of the current YTD, in other words 0-YTD, not the budgeted as desired. For reference if it helps, the columns a Budget C74 Rev 1 E74 Rev 2 G74 YTD I74 Thanks "DaveO" wrote: Hi, Deb- Let's say the budget column is A, the first revision column is B, the second revision column is C; actuals YTD are in D, and the Balance formula is in E. Let's assume the revisions are blank until they are updated, since it's possible for a budget to be revised to zero. (Trying to avoid a logic flaw, here.) Try this formula: =IF(C4<"",C4-D4,IF(B4<"",B4-D4,A4-D4)) It works from right to left to find the first non-blank entry starting with revision 2; if revision 2 is blank it checks for a revision 1; if rev 1 is blank it performs the math on the original budget amount. Will that get you where you need to go? Dave O |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine logical formulas "if", "and", "or" | Excel Discussion (Misc queries) | |||
| logical formulas in excel | Excel Discussion (Misc queries) | |||
| Logical Value | Excel Worksheet Functions | |||
| Can logical formulas be used to build accounts receivable workshe. | Excel Worksheet Functions | |||
| Logical Function | Excel Worksheet Functions | |||
Threaded Mode
