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
73068214908
932110173852
82119097886
723382761043
702580251000
66827523841
986609866
851008510
747507475
707507075
693506935--
kelljeff
------------------------------------------------------------------------
kelljeff's Profile: www.excelforum.com/member.php...oamp;userid=32007
View this thread: www.excelforum.com/showthread...hreadid=542441IF(Actualgt;0,Actual-Forecast,0)

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

=IF(B2gt;0,B2-A2,0)
--
Kevin Backmannquot;kelljeffquot; wrote:

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; ForecastActualVariance
gt; 73068214908
gt; 932110173852
gt; 82119097886
gt; 723382761043
gt; 702580251000
gt; 66827523841
gt; 986609866
gt; 851008510
gt; 747507475
gt; 707507075
gt; 693506935
gt;
gt;
gt; --
gt; kelljeff
gt; ------------------------------------------------------------------------
gt; kelljeff's Profile: www.excelforum.com/member.php...oamp;userid=32007
gt; View this thread: www.excelforum.com/showthread...hreadid=542441
gt;
gt;


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: www.excelforum.com/member.php...oamp;userid=17084
View this thread: www.excelforum.com/showthread...hreadid=542441in YOUR particular scenario, try this.
=IF(G1lt;1,quot;quot;,MAX(F1:G1)-MIN(F1:G1))
or substitute quot;quot; for $a$1??

--
Don Guillett
SalesAid Software

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; 7306 8214 908
gt; 9321 10173 852
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; 7075 0 7075
gt; 6935 0 6935
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=542441
gt;