| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MY FORMULA WILL NOT WORK
This is the formula I have and the chart I'm using can anyone help?
=IF(C10<=55,5,IF(C10=0,"NO VALUE",IF(C10=85.1,1,IF(C10=75.1-85,2,IF(C10=60-75,3,IF(C10=55.1-59.99,4)))))) 0-55 will be 5 points. 55.1-59.99 will be 4 points 60-75 will be 3 points 75.1-85 will be 2 points 85.1 and up will be 1 point 1 is highest! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
MY FORMULA WILL NOT WORK
Maybe
=IF(C10=85.1,1,IF(C10=75.1,2,IF(C10=60,3,IF(C10 =55.1,4,IF(C100,5,IF(C10<=0,"N0 Score")))))) Mike "BOO19422" wrote: This is the formula I have and the chart I'm using can anyone help? =IF(C10<=55,5,IF(C10=0,"NO VALUE",IF(C10=85.1,1,IF(C10=75.1-85,2,IF(C10=60-75,3,IF(C10=55.1-59.99,4)))))) 0-55 will be 5 points. 55.1-59.99 will be 4 points 60-75 will be 3 points 75.1-85 will be 2 points 85.1 and up will be 1 point 1 is highest! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
MY FORMULA WILL NOT WORK
start at the highest and work down
=IF(C1085,1,IF(C1075,2,IF(C1060,3,IF(C1055,4,I F(C10=0,5,0))))) -- Don Guillett Microsoft MVP Excel SalesAid Software "BOO19422" wrote in message ... This is the formula I have and the chart I'm using can anyone help? =IF(C10<=55,5,IF(C10=0,"NO VALUE",IF(C10=85.1,1,IF(C10=75.1-85,2,IF(C10=60-75,3,IF(C10=55.1-59.99,4)))))) 0-55 will be 5 points. 55.1-59.99 will be 4 points 60-75 will be 3 points 75.1-85 will be 2 points 85.1 and up will be 1 point 1 is highest! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
MY FORMULA WILL NOT WORK
Try this:
=LOOKUP(C10,{0,55.1,60,75.1,85.1},{5,4,3,2,1}) -- Biff Microsoft Excel MVP "BOO19422" wrote in message ... This is the formula I have and the chart I'm using can anyone help? =IF(C10<=55,5,IF(C10=0,"NO VALUE",IF(C10=85.1,1,IF(C10=75.1-85,2,IF(C10=60-75,3,IF(C10=55.1-59.99,4)))))) 0-55 will be 5 points. 55.1-59.99 will be 4 points 60-75 will be 3 points 75.1-85 will be 2 points 85.1 and up will be 1 point 1 is highest! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
MY FORMULA WILL NOT WORK
That did the trick...Thanks for your help !!
"BOO19422" wrote: This is the formula I have and the chart I'm using can anyone help? =IF(C10<=55,5,IF(C10=0,"NO VALUE",IF(C10=85.1,1,IF(C10=75.1-85,2,IF(C10=60-75,3,IF(C10=55.1-59.99,4)))))) 0-55 will be 5 points. 55.1-59.99 will be 4 points 60-75 will be 3 points 75.1-85 will be 2 points 85.1 and up will be 1 point 1 is highest! |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
MY FORMULA WILL NOT WORK
We are ALL glad you liked it
-- Don Guillett Microsoft MVP Excel SalesAid Software "BOO19422" wrote in message ... That did the trick...Thanks for your help !! "BOO19422" wrote: This is the formula I have and the chart I'm using can anyone help? =IF(C10<=55,5,IF(C10=0,"NO VALUE",IF(C10=85.1,1,IF(C10=75.1-85,2,IF(C10=60-75,3,IF(C10=55.1-59.99,4)))))) 0-55 will be 5 points. 55.1-59.99 will be 4 points 60-75 will be 3 points 75.1-85 will be 2 points 85.1 and up will be 1 point 1 is highest! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Max value formula doesn't work | Excel Discussion (Misc queries) | |||
| Is this formula going to work? | Excel Worksheet Functions | |||
| FORMULA DOESN'T WORK | Excel Discussion (Misc queries) | |||
| A search for $ in a formula use to work now it does not work | Excel Discussion (Misc queries) | |||
| formula won't work | Excel Worksheet Functions | |||
Linear Mode
