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

Use an "OR" around nested IF statements 2
match formula 2
IF - AND - OR statement? 4
Need greater than = .. less than = combined with index/match state 8
Compute Additional Hours Needed Using "if" or "lookup" 1
Return a value if a range of cells contain text 2
AVERAGE NON-ZERO CELLS ACROSS SEVERAL WORKSHEETS IN SAME WORKBOOK 8
Cumulative formula for word table 0

Top