| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
