leave a cell blank

  • Thread starter Thread starter shank
  • Start date Start date
S

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!
 
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
 
Or you could use Conditional Formatting to set font colour to white (or same
as background)
 
Back
Top