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