IF formula
 

I need to create what I would think would be an IF formula for quite a large
group of measurements. Here is an example of what I am working with...

A B
Score Rating
55%

Here are the measurements below of how column B would reflect
NM = <50
MS = 50-52.9
ME = 53 -55.9
FE = 56-59.9
SE = or 60

Any easy ideas with the formula to use?

IF formula
 

I assume your score is formatted as % so the true underlying value is
actually 0.55.

=IF(A1="","",LOOKUP(A1,{0,0.5,0.53,0.56,0.6},{"NM" ,"MS","ME","FE","SE"}))

Biff

"casdaq" wrote in message
...
I need to create what I would think would be an IF formula for quite a
large
group of measurements. Here is an example of what I am working with...

A B
Score Rating
55%

Here are the measurements below of how column B would reflect
NM = <50
MS = 50-52.9
ME = 53 -55.9
FE = 56-59.9
SE = or 60

Any easy ideas with the formula to use?

IF formula
 

=IF(A1<50,"NM",IF(A1<53,"MS",IF(A1<56,"ME",IF(A1<6 0,"FE","SE"))))

I've guessed what you might want to do for numbers between 52.9 and 53, and
between 55.9 and 56, and between 59.9 and 60.
--
David Biddulph

"casdaq" wrote in message
...
I need to create what I would think would be an IF formula for quite a
large
group of measurements. Here is an example of what I am working with...

A B
Score Rating
55%

Here are the measurements below of how column B would reflect
NM = <50
MS = 50-52.9
ME = 53 -55.9
FE = 56-59.9
SE = or 60

Any easy ideas with the formula to use?

IF formula
 

in B1:

=LOOKUP(A1,{0,50,53,56,60},{"NM","MS","ME","FE","S E"})

"casdaq" wrote:

I need to create what I would think would be an IF formula for quite a large
group of measurements. Here is an example of what I am working with...

A B
Score Rating
55%

Here are the measurements below of how column B would reflect
NM = <50
MS = 50-52.9
ME = 53 -55.9
FE = 56-59.9
SE = or 60

Any easy ideas with the formula to use?

IF formula
 

Thank you both - formula worked perfectly!

"Toppers" wrote:

in B1:

=LOOKUP(A1,{0,50,53,56,60},{"NM","MS","ME","FE","S E"})

"casdaq" wrote:

I need to create what I would think would be an IF formula for quite a large
group of measurements. Here is an example of what I am working with...

A B
Score Rating
55%

Here are the measurements below of how column B would reflect
NM = <50
MS = 50-52.9
ME = 53 -55.9
FE = 56-59.9
SE = or 60

Any easy ideas with the formula to use?