Need some help.

I have forecasted sales, actual sales and % variance.

The forumla I have currently is: =IF(B38=0,"",B38/B4). I need it to
show the following: if forecasted amount is o and actual is greater
than 1.00 it should read "unplanned sales". If actual is 0 and Forecast
is greater than 1 I need it to read "-100%".

Otherwise I need to dived actual sales by forecast amount to get the
actual % variance.

Does this make sense? Can someone help me?

Thanks,
Josh


--
streetboarder
------------------------------------------------------------------------
streetboarder's Profile: http://www.excelforum.com/member.php...o&userid=30707
View this thread: http://www.excelforum.com/showthread...hreadid=503708