Hi and an IF statement question

**Johnmitch93** · 11-11-2011, 04:12 PM

Hi - I have just registered on here, so wandering around a little having a look.

Anyway, my first question.

I have this IF statement, which does the job, but I need to add two more brackets. Obviously, I can't due to the '7' limit.

=IF(Z:Z="K3","YES",IF(Z:Z="K4","YES",IF(Z:Z="K5","YES",IF(Z:Z="K6","YES",IF(Z:Z="K7","YES",IF(Z:Z="K8","YES",IF(Z:Z="K9","YES",IF(Z:Z="KA","YES","NO KR"))))))))

Any ideas gratefully accepted.

Cheers,
John.

**SDBoca** · 11-11-2011, 04:58 PM

You should consider creating a two column table with K3 - Yes, K4 - Yes, and so on. Then use VLookup to lookup the appropriate value (Yes, No KR)

**ChemistB** · 11-11-2011, 05:09 PM

Another solution;

=IF(OR(Z:Z={"KA","K4","K5","K6","K7","K8","K9","K0"}),"Yes","No")
Does that work for you?

Wondering why you're using Z:Z instead of referencing a specific cell?

**Johnmitch93** · 11-11-2011, 05:21 PM

Sorted job!

Chemist B - I used your solution and it worked a treat.
Then I thought, why not reference a specific cell, as in replace Z:Z with Z2 etc.
That works too!
As for why I didn't at first - well, it was what I knew and it worked...

SDBoca - I will have a bash at your solution over the weekend and see what occuurs.

Cheers all,
John.

Now, how to mark the thread "resolved"...

**ConneXionLost** · 11-11-2011, 05:23 PM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save