If or formula help please
 

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

If or formula help please
 

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


--
__________________________________
HTH

Bob

"Diddy" wrote in message
...
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

If or formula help please
 

Lovely !

Thank you
--
Deirdre


"Bob Phillips" wrote:

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


--
__________________________________
HTH

Bob

"Diddy" wrote in message
...
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

If or formula help please
 

Bob's answer is best but here is another
=10*(K3="Y")+20*(K3="N")
Format cell so that zeros are not displayed
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Diddy" wrote in message
...
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