Return a given value if the value of a cell is in a given range

V

vlpckett

I have a large spreadsheet of information that I am trying to simplify by
creating a "group" column. I need to build a formula that will look at the
number value in another cell and return a letter value based upon where
number value falls in my predetermined range.

For example; The formula will be in cell B1. I want to look at the number
value in cell A1. If the value in A1 is 10-50, 80 or 81 I want "F" to appear
in B1. If the value in A1 is 60-69 I want "V" to appear in B1.
 
M

Mike H

Hi,

=IF(OR(AND(A1>=10,A1<=50),AND(A1>=80,A1<=81)),"F",IF(AND(A1>=60,A1<=69),"V",""))

mind the line wrap it's all one line.

Mike
 
S

Shane Devenshire

Hi,

What happens to values between 51-59, 71-79 and over 81 or under 10?

=If(OR(AND(A1>=10,A1<=50),A1=80,A1=81),"F","V")

This assumes there are no values in the other ranges you did not address.
 

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

Scrabble Value calculation for Welsh words 0
Return the value from one range that does not exist in another 0
With F1 value, look at A, if match or partial match return B 5
How do I put a blank value in a cell not using "" in a formula 2
Comparing a cell value to a range 4
Excel In Excel how can I block the contenent of a cell? 0
How do I have a cell value define a dynamic named range? 15
Formula (or code) return the largest number of duplicates in a list. 16

Top