The formula is: =IF(L4="cir",P4,0) The figure in P4 is always positive.
I've tried putting

"Nick Hodge" wrote:

If the positive figure is in A1 a - in the formula and it doesn't work

=-A1

But I suspect it's more complicated than that???

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"judgejulz" wrote in message
...
How can I make all the cells in one column appear as a negative if they
contain a formula that inserts a positive figure?