Hi,
I may have misunderstood, but does this help...
Put your forecast figures in row 1 as normal & in row 2 (you may want
to insert another row) type "=if(A5<0,0,a1)" & format the cell for
pounds.
Hth,
Rob Brockett
NZ
I'm still learning & the best way to learn is to experience...
--
broro183
------------------------------------------------------------------------
broro183's Profile:
http://www.excelforum.com/member.php...o&userid=30068
View this thread:
http://www.excelforum.com/showthread...hreadid=500074