IF function. BLANK if BLANK please!

[28creation]

Hi all,

Hope you can help me with this little annoyance....


Section Score Pass/Development/Fail
1 Pass
2 Pass
3 Pass


This is the formula that's in the first "Pass" box, opposite "1".

=IF(H28>=90%,"Pass",IF(H28>=75%,"Development Pass",IF(H28<=75%,"Fail")))

The three boxes (H28, 29 & 30) fill up based on results further up the page, & when they're included boxes I28, 29 & 30 alter what they say, ie Pass, Development Pass or Fail.

Yet they say "Pass" automatically, even though there's nothing in the box.

How can I get it to be blank when there's nothing in the H boxes?

So annoying.

Any thoughts please guys?

Thanks.

NB - the three passes are below Pass/Development/Fail & the three boxes below score are blank.

 

[Jonmo1]

Try

=IF(H28="","",IF(H28>=90%,"Pass",IF(H28>=75%,"Development Pass",IF(H28<=75%,"Fail"))))

 

[steve the fish]

Id expect it to say Fail if H28 was empty??

 

[Comfy]

You can use an If statement to check if the cell is blank.

I have used different functions to establish the Pass/Fail etc because I don't like too many nested IFS (personal preference)

Excel 2010
	H	I
28	0.75	Fail
29	0.76	Development Pass
30	0.9	Pass
Sheet1

Cell Formulas
Range	Formula
I28	=IF(NOT(ISBLANK(H28)),CHOOSE(MATCH(H28,{1,0.8999999,0.75},-1),"Pass","Development Pass","Fail"),"")

 

[Jonmo1]

Id expect it to say Fail if H28 was empty??

I believe the issue is that H28 is NOT empty.
It's a formula resulting in ""

The three boxes (H28, 29 & 30) fill up based on results further up the page

A formula that returns "" is NOT blank, it's a Text String.
And > < operators consider Text to be greater than numbers.
So H28>=90% = TRUE, result of IF is "Pass"

 

[steve the fish]

Yeah sorry I did just read it was result of formula. Sometimes don't see for looking...

 

[28creation]

Thanks for all your help, all sorted now.

Nice one!!

 

[Jonmo1]

You're welcome.