# Excel 2008 Formula Question

Hello,

Can someone please look at the attached sample and explain why, in cell BD4, the formula is generating a 'Pass'?  I cant seem to trace the logic as to why its not showing a blank (which it should at this point).

Thanks!
EE-Sample.xlsb
LVL 1
###### Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Commented:
You are using this calculation (as a named range)

=IF(OR('Candidate Data'!\$AQ4="Declined",'Candidate Data'!\$AR4="Declined"),"Declined",IF(AND('Candidate Data'!\$BC4>0,'Candidate Data'!\$BC4<3),"Fail",IF(AND('Candidate Data'!\$AN4="Pass",'Candidate Data'!\$BC4=""),"Pending",IF('Candidate Data'!BC4>=3,"Pass",""))))

'Candidate Data'!BC4 contains a null string "" which is a text value and deemed to be greater than 3, perhaps change to this

=IF(OR('Candidate Data'!\$AQ4="Declined",'Candidate Data'!\$AR4="Declined"),"Declined",IF(AND('Candidate Data'!\$BC4>0,'Candidate Data'!\$BC4<3),"Fail",IF(AND('Candidate Data'!\$AN4="Pass",'Candidate Data'!\$BC4=""),"Pending",IF(N('Candidate Data'!BC4)>=3,"Pass",""))))

that will deem any text value to be zero and you'll get a blank as required

regards, barry
0

Experts Exchange Solution brought to you by