ExcelBanter - If question... I think!

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - If question... I think! (https://www.excelbanter.com/excel-discussion-misc-queries/88793-if-question-i-think.html)

kelljeff

If question... I think!

This is probably really easy but I can't get it to work. Please help!!!

Below is a sample of the spreadsheet...
I only want the variance to appear when there is something in the
actual field.
Here is what try IF((B18C18),(B18-C18),IF((C18B18),(C18-B18),$A$1)).

Forecast Actual Variance
7306 8214 908
9321 10173 852
8211 9097 886
7233 8276 1043
7025 8025 1000
6682 7523 841
9866 0 9866
8510 0 8510
7475 0 7475
7075 0 7075
6935 0 6935

--
kelljeff
------------------------------------------------------------------------
kelljeff's Profile: http://www.excelforum.com/member.php...o&userid=32007
View this thread: http://www.excelforum.com/showthread...hreadid=542441

Kevin B

If question... I think!

IF(Actual0,Actual-Forecast,0)

Example, assuming that Forecasts are in column A and actuals are in column B:

=IF(B20,B2-A2,0)
--
Kevin Backmann

"kelljeff" wrote:

This is probably really easy but I can't get it to work. Please help!!!

Below is a sample of the spreadsheet...
I only want the variance to appear when there is something in the
actual field.
Here is what try IF((B18C18),(B18-C18),IF((C18B18),(C18-B18),$A$1)).

Forecast Actual Variance
7306 8214 908
9321 10173 852
8211 9097 886
7233 8276 1043
7025 8025 1000
6682 7523 841
9866 0 9866
8510 0 8510
7475 0 7475
7075 0 7075
6935 0 6935

--
kelljeff
------------------------------------------------------------------------
kelljeff's Profile: http://www.excelforum.com/member.php...o&userid=32007
View this thread: http://www.excelforum.com/showthread...hreadid=542441

Gary Brown

If question... I think!

If you don't want to see a variance when the actual is 0, then can't you
do:-

If(C18=0,0,C18-B18)

--
Gary Brown
------------------------------------------------------------------------
Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084
View this thread: http://www.excelforum.com/showthread...hreadid=542441

Don Guillett

If question... I think!

in YOUR particular scenario, try this.
=IF(G1<1,"",MAX(F1:G1)-MIN(F1:G1))
or substitute "" for $a$1??

--
Don Guillett
SalesAid Software

"kelljeff" wrote in
message ...

This is probably really easy but I can't get it to work. Please help!!!

Below is a sample of the spreadsheet...
I only want the variance to appear when there is something in the
actual field.
Here is what try IF((B18C18),(B18-C18),IF((C18B18),(C18-B18),$A$1)).

Forecast Actual Variance
7306 8214 908
9321 10173 852
8211 9097 886
7233 8276 1043
7025 8025 1000
6682 7523 841
9866 0 9866
8510 0 8510
7475 0 7475
7075 0 7075
6935 0 6935

--
kelljeff
------------------------------------------------------------------------
kelljeff's Profile:
http://www.excelforum.com/member.php...o&userid=32007
View this thread: http://www.excelforum.com/showthread...hreadid=542441

All times are GMT +1. The time now is 03:25 AM.