ExcelBanter - If question I think

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - If question I think (https://www.excelbanter.com/excel-worksheet-functions/88815-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
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

Ardus Petus

If question I think

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

HTH
--
AP

"kelljeff" a écrit
dans le message de news:
...

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
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

If question I think

kelljeff

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

Beege

"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
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

All times are GMT +1. The time now is 07:17 PM.