If question I think

[kelljeff]

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

Forecast Actual Variance
8211 9097 886
7233 8276 1043
7025 8025 1000
6682 7523 841
9866 0 9866
8510 0 8510
7475 0 7475

[Ardus Petus]

=IF(AND(B18="",c18=""),"",IF(B18=C18,$A$1,ABS(B18-C18))

HTH
--
AP

"kelljeff" <[email protected]> a écrit
dans le message de news:
[email protected]...
>
> 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((B18>C18),(B18-C18),IF((C18>B18),(C18-B18),$A$1)).
>
> Forecast Actual Variance
> 8211 9097 886
> 7233 8276 1043
> 7025 8025 1000
> 6682 7523 841
> 9866 0 9866
> 8510 0 8510
> 7475 0 7475
>
>
> --
> kelljeff
> ------------------------------------------------------------------------
> kelljeff's Profile:
> http://www.excelforum.com/member.php...o&userid=32007
> View this thread: http://www.excelforum.com/showthread...hreadid=542439
>

[Beege]

kelljeff

=IF(OR(B18="",B18=0),"",ABS(A18-B18))

Beege

"kelljeff" <[email protected]> wrote in
message news:[email protected]...
>
> 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((B18>C18),(B18-C18),IF((C18>B18),(C18-B18),$A$1)).
>
> Forecast Actual Variance
> 8211 9097 886
> 7233 8276 1043
> 7025 8025 1000
> 6682 7523 841
> 9866 0 9866
> 8510 0 8510
> 7475 0 7475
>
>
> --
> kelljeff
> ------------------------------------------------------------------------
> kelljeff's Profile:
> http://www.excelforum.com/member.php...o&userid=32007
> View this thread: http://www.excelforum.com/showthread...hreadid=542439
>