If statement
in [Functions]
|
From: Donna on 3 Feb 2010 15:09 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)))
From: Teethless mama on 3 Feb 2010 15:29 =IF(D13<0,D4-D22,IF(D13>0,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))) >
From: Donna on 3 Feb 2010 16:18 Mama - you are awesome! "Teethless mama" wrote: > =IF(D13<0,D4-D22,IF(D13>0,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))) > >
From: Donna on 3 Feb 2010 16:24 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(D13>0,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))) > >
|
Pages: 1 Prev: count cells in a table that meet multiple criteria Next: Conditional Format Tracker by Date |