leave a cell blank

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

shank - 06 Apr 2008 21:50 GMT

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!

Reply to this Message

Gord Dibben - 06 Apr 2008 22:11 GMT

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

>My spreadsheet serves 2 purposes. Printed and manually filled out plus data
>entry.
[quoted text clipped - 8 lines]
>
>thanks!

Reply to this Message

Castell - 06 Apr 2008 22:16 GMT

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

> My spreadsheet serves 2 purposes. Printed and manually filled out plus
> data entry.
[quoted text clipped - 8 lines]
>
> thanks!

Reply to this Message