It's because your nested IF doesn't make sense.

You have IF(B23-B22,"$0.00",B23-B22)

It's the first B23-B22 that's causing the problem

Did you intend something like: IF(B23<B22,"$0.00",B23-B22) ?

or IF(B23-B22<0,"$0.00",B23-B22) ?


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=512851