Assistance please.

[John Holt]

I have created a worksheet that uses currency formatted cells.
Cell F2 contains the formula: =A2+B2+D2+E2 which works fine.
However when I copy and paste from cell F2 to other cells in column F ie.
F3 thru to F9 the figures $0.00 appear, in these cells. I wish to remove
these figures ie. show blank cells without removing the formulas from these
cells.What do I need to add to the abovementioned formula to make this
happen.

Thanks for your help!!

Regards
John Holt

 

[Bob Greenblatt]

I have created a worksheet that uses currency formatted cells.
Cell F2 contains the formula: =A2+B2+D2+E2 which works fine.
However when I copy and paste from cell F2 to other cells in column F ie.
F3 thru to F9 the figures $0.00 appear, in these cells. I wish to remove
these figures ie. show blank cells without removing the formulas from these
cells.What do I need to add to the abovementioned formula to make this
happen.

Thanks for your help!!

Regards
John Holt

I assume the zeros appear because there is nothing in the referenced cells
(a3,b3,d3,e3) for example. You could do several things:
1) format the cells so that zeros do not appear "0.00;(0.00);"
2) change the formula to something like:=if(a2+b2+d2+e2>0,a2+b2+d2+e2,"")

Either should get rid of your zeros.