Software

Ask something
Discussion Locked

Excel 97 Formula Hiding

0 helpful
3 replies

by joshua miller

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a client who wants to have a spreadsheet that has 3 columns with alot of formulas in them but its all zero's until they fill them in. They want to hide the formula results until they enter data in the KEY column. Any other info email me and Iwill send you a copy of the spreadsheet. Thanks! joshmiller@myvine.com

3 replies

by dklippert

I'll be gald to look at it.
There are a number of ways to do it. If you go to Tools>Options and choose the View tab, you can take the checkmark out of Zero values. Now the spreadsheet wil not show ANY zero values.

You could also use an If statement:

=If(A1+B1=0,"",A1+B1)

If the formula is zero, nothing is displayed (two quotes with no space between equals nothing)
If not then the formula is evaluated.
Instead of "" You could use "This has not been computed" etc.

This discussion is closed to new replies.