Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If statement
I need a formula that will help me produce the correct answer in this
scenario: If Revised forecast is <0 then Forecast - Actual, if Revised Forecast is 0 then Revised Forecast - Actual Forecast 360 Revised Forecast 600 Actual 10 Variance 590 This formula is not working - =IF(D13<"0",SUM(D4-D22),IF(D13"0",SUM(D13-D22))) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF statement inside a SUMIF statement.... or alternative method | Excel Worksheet Functions | |||
Reconcile Bank statement & Credit card statement & accounting data | Excel Worksheet Functions | |||
Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
Sum if statement with a left statement | Excel Discussion (Misc queries) | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions |