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