Software

Ask something
Discussion Locked

Hide FALSE in an EXCEL sheet

0 helpful
4 replies

by lathe 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
When I use some formula in EXCEL XP I'm geting FALSE in few sells, as per formula the result is correct but I don't want the FALSE to appear in the sheet, any way ?

4 replies

by brian

You can eliminate this by adding to the formula and specifying "" which stands for nothing as the response for False.

Here is an example with an IF formula
Displays FALSE: =IF(B1>1,"yes")
FIX: =IF(B1>1,"yes","")

by lathe

My formula is
=IF(C15>30,IF(C15<=60,D15,0))
When the value of C15 = 10 the result will be FALSE
Any Solution

by lathe

My formula is
=IF(C15>30,IF(C15<=60,D15,0))
When the value of C15 = 10 the result will be FALSE.
Any Solution ?

This discussion is closed to new replies.