If help please

[Bob]

I have the following

=IF(OR(C5="a",C5="b",C5="c"),"YES","NO")

But need to add another variable, if C5 has KS1 entered ( means Key skills 1
attained ) I need the cell to the formula is in to show KS1

Probably easy for someone who is used to this, but a nightmare for me !

Thanks in advance

Bob

 

[Frank Kabel]

Hi
try
=IF(C5="KS1","KS1",IF(OR(C5="a",C5="b",C5="c"),"YES","NO"))

 

[Bob]

many thanks, super quick reply. if you only knew how many hours I spend
trying to get the rest of this spreadsheet to work!!!

Trying to make the English education entry requirements simpler to
understand !!!
Bob