If number (Combo! Formula) If blank Cell Blank...

**Zees** · 09-24-2010, 04:45 PM

So sadly this is already my second pity post for the day..
I cant figure this formula out, Ive been reading through the tutorials and then searching the forums for similar questions but cant get it down.

Basically,

If A1 has a number in it that is greater than 1.5 but less than 4.6 than I need cell A2 to say "Pass", If it out of that range I need it to say "Fail"... But if A1 is empty I need it to be blank..

My lame attempt was =IF(AND( ISNUMBER(E5),E5>1.5,E5<4.6),"Pass", "Fail")
But then I got lost when trying to make it blank when no number is present...

Then I thought HEY ill steal NBVC's genius from my last post and tweak it with =IF(E5="","",(AND( ISNUMBER(E5),E5>1.5,E5<4.6),"Pass", "Fail")
and then whole thing stops working

Anyone wanna take pity on me?

Thanks in advance!

~Zees

**zbor** · 09-24-2010, 04:53 PM

There is no stupid questions my friend, only stupid answers

So no need to be ashamed

But still need to ask you to change title name according to the rules:

1. Use concise, accurate thread titles. Your post title should describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change the title of the thread, click EDIT on the original post, then click the Go Advanced button, then change the title. If two or more hours have passed, the EDIT button will not appear, and you need to ask a moderator to change the title.

**Zees** · 09-24-2010, 04:57 PM

My Apologies. Title changed
See thats the stupidity coming out again!

**zbor** · 09-24-2010, 04:58 PM

You missing one more IF:

=IF(E5="","", IF(AND( ISNUMBER(E5),E5>1.5,E5<4.6),"Pass", "Fail") )

**Zees** · 09-24-2010, 05:02 PM

Thwarted by a simple IF....Grrr

Many Thanks Zbor! You rock!

**daddylonglegs** · 09-24-2010, 05:46 PM

I doubt if you need ISNUMBER as there won't be any entries in E5 that could be between 1.5 and 4.6 that aren't numbers, hence you should be able to use just

=IF(E5="","",IF(AND(E5>1.5,E5<4.6),"Pass", "Fail"))