If or formula help please

D

Diddy

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
 
B

Bernard Liengme

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need greater than = .. less than = combined with index/match state 6
IF - AND - OR statement? 3
match formula 2
Help Please calculating date range - Other posts didn't help 6
Formula to calculate 4 possible answers in one cell 3
AVERAGE NON-ZERO CELLS ACROSS SEVERAL WORKSHEETS IN SAME WORKBOOK 7
Mulitple "IF/OR" statments 3
formula 1

Top