Hi everyone,

What can I do to make this work?

I want it to look at cells in column K and if they contain Y or No return 10
and 20 respectively. Problem is if the cell does not contain either Y or N it
contains a number and this also returns 20.

Here's my formula

=IF(OR(K3="Y",K3="N"),10,20)

Thanks in advance
Diddy
--
Deirdre