leave a cell blank

[shank]

My spreadsheet serves 2 purposes. Printed and manually filled out plus data
entry.

The cells with formulas show a 0 (zero) if the referenced cells are empty.

The problem is the user has the option to ignore the formula and hard code a
figure.

If a formula = 0, is there a way to hide that zero so when I print the form
it's blank for the user?

thanks!

 

[Gord Dibben]

You could turn off viewing zeros at Tools>Options>View.

Or you could trap for the 0 and leave cell looking blank.

=IF(A1*B1=0,"",A1*B1)

If you are interested in keeping the user from over-writing a formula, see help
on cell locking and sheet protection.


Gord Dibben MS Excel MVP

 

[Castell]

Or you could use Conditional Formatting to set font colour to white (or same
as background)