| 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))) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If statement
=IF(D13<0,D4-D22,IF(D130,D13-D22,""))
"Donna" wrote: 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))) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If statement
Mama - you are awesome!
"Teethless mama" wrote: =IF(D13<0,D4-D22,IF(D130,D13-D22,"")) "Donna" wrote: 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))) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If statement
Just to complicate things.
If there is no revised forecast how can I modify this formula to return the original forecast? Forecast 360 Revised Forecast 0 Actual 10 Variance 350 Can one formula handle either situation? "Teethless mama" wrote: =IF(D13<0,D4-D22,IF(D130,D13-D22,"")) "Donna" wrote: 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))) |
| Reply |
| 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 | |||
Linear Mode
