Not displaying 0 in formula cell

[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?

 

[Andrew]

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

 

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

 

[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)

 

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

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)

 

[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

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.

 

[Kevin O`Brien]

Great, thanks very much.

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.