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