software

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((B18gt;C18),(B18-C18),IF((C18gt;B18),(C18-B18),$A$1)).

ForecastActualVariance
82119097886
723382761043
702580251000
66827523841
986609866
851008510
747507475--
kelljeff
------------------------------------------------------------------------
kelljeff's Profile: www.excelforum.com/member.php...oamp;userid=32007
View this thread: www.excelforum.com/showthread...hreadid=542439=IF(AND(B18=quot;quot;,c18=quot;quot;),quot;quot;,IF(B18=C18,$A$1,ABS(B18-C18))

HTH
--
AP

quot;kelljeffquot; gt; a écrit
dans le message de news:
...
gt;
gt; This is probably really easy but I can't get it to work. Please help!!!
gt;
gt;
gt; Below is a sample of the spreadsheet...
gt; I only want the variance to appear when there is something in the
gt; actual field.
gt; Here is what try IF((B18gt;C18),(B18-C18),IF((C18gt;B18),(C18-B18),$A$1)).
gt;
gt; Forecast Actual Variance
gt; 8211 9097 886
gt; 7233 8276 1043
gt; 7025 8025 1000
gt; 6682 7523 841
gt; 9866 0 9866
gt; 8510 0 8510
gt; 7475 0 7475
gt;
gt;
gt; --
gt; kelljeff
gt; ------------------------------------------------------------------------
gt; kelljeff's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32007
gt; View this thread: www.excelforum.com/showthread...hreadid=542439
gt;
kelljeff

=IF(OR(B18=quot;quot;,B18=0),quot;quot;,ABS(A18-B18))

Beege

quot;kelljeffquot; gt; wrote in
message ...
gt;
gt; This is probably really easy but I can't get it to work. Please help!!!
gt;
gt;
gt; Below is a sample of the spreadsheet...
gt; I only want the variance to appear when there is something in the
gt; actual field.
gt; Here is what try IF((B18gt;C18),(B18-C18),IF((C18gt;B18),(C18-B18),$A$1)).
gt;
gt; Forecast Actual Variance
gt; 8211 9097 886
gt; 7233 8276 1043
gt; 7025 8025 1000
gt; 6682 7523 841
gt; 9866 0 9866
gt; 8510 0 8510
gt; 7475 0 7475
gt;
gt;
gt; --
gt; kelljeff
gt; ------------------------------------------------------------------------
gt; kelljeff's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32007
gt; View this thread: www.excelforum.com/showthread...hreadid=542439
gt;