Not displaying 0 in formula cell

K

Kevin O`Brien

I have a column of cells which all contain the same formula:
eg. =C20-(C20/1.175)

As this is a currency cell, even if there is calculation can be done on it
yet because there are no values in the cells required, it displays £0.00

Is it possible for this cell to be blank in this case?
 
K

Kevin O`Brien

Thanks, it works, but when I do a print preview it still tries to print of
the extra cells even though they are blank.
 
B

Bob Phillips

As this must arise from C20 being 0, try

=IF(C20=0,"",C20-(C20/1.175))

or use conditional formatting to set the font colour to white on a zero
value

or even use a csutom format of

$#,##0.00;-$#,##0.00;""

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
K

Kevin O`Brien

Yes, I actually did use:
=IF(C20="","",C20-(C20/1.175))

However, as I have just replied to the previous posts message when I do a
print preview it still tries to print the extra cells even though they are
blank.


Bob Phillips said:
As this must arise from C20 being 0, try

=IF(C20=0,"",C20-(C20/1.175))

or use conditional formatting to set the font colour to white on a zero
value

or even use a csutom format of

$#,##0.00;-$#,##0.00;""

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
Click to expand...
 
D

DDM

Kevin, the cells may be blank but they're not empty. That's why Excel wants
to print them.
Select the range you want to print, then File > Print Area > Set Print Area.

--
DDM
"DDM's Microsoft Office Tips and Tricks"
Visit us at www.ddmcomputing.com


Kevin O`Brien said:
Yes, I actually did use:
=IF(C20="","",C20-(C20/1.175))

However, as I have just replied to the previous posts message when I do a
print preview it still tries to print the extra cells even though they are
blank.
Click to expand...
 
K

Kevin O`Brien

Great, thanks very much.

DDM said:
Kevin, the cells may be blank but they're not empty. That's why Excel wants
to print them.
Select the range you want to print, then File > Print Area > Set Print Area.
Click to expand...
 
Top