hide the returned value "false" I have submerged zero values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Although I have submerged zero values, and hidden formulas, the cell still
displays "false" when the if statement has not been met. How can I have the
word "false" submerged.
 
Hi!

Use a return of zero in your IF function when the logical test is FALSE.

An alternative, use conditional formatting to hide them.

Conditional Formatting:
Cell value is: equal to: FALSE
Set the font color to be the same as the background color

Biff
 
=IF(A1=X,200,"")

meaning if the condition is not met return blank

adapt to fit

--
Regards,

Peo Sjoblom

(No private emails please)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

copy paste value 1
Nested If/And/Or statements 4
Searching the formula (not the value) for a text string 1
Return Blank Cell in case of false If 3
Excel How to get output of the formula instead of True or false 1
How do I ignore cell values of zero? 2
OR function problem 16
Automatically Hide rows with a value of zero 2

Back
Top