Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Easy Excel Formula
Hello & greetins from South Texas. I've created a numerical report in excel
using the autosum feature. I need to formulate a "High", "Medium", "Low" result. If the number is 33 or more this will be a "High."; 23-32 = "Medium"; 1-22 = "Low." Can you please help? Thank you. John |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Easy Excel Formula
=IF(A1=33,"High",IF(A122,"Medium",IF(A1=1,"Low" ,"")))
Vaya con Dios, Chuck, CABGx3 "Skydiver" wrote: Hello & greetins from South Texas. I've created a numerical report in excel using the autosum feature. I need to formulate a "High", "Medium", "Low" result. If the number is 33 or more this will be a "High."; 23-32 = "Medium"; 1-22 = "Low." Can you please help? Thank you. John |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Easy Excel Formula
"Vaya con Dios" is right. Skydiving was fun while it lasted. Nonetheless,
I'm still here. Anyway, thanks for the quick response Chuck. It worked. You guys are awesome. "CLR" wrote: =IF(A1=33,"High",IF(A122,"Medium",IF(A1=1,"Low" ,""))) Vaya con Dios, Chuck, CABGx3 "Skydiver" wrote: Hello & greetins from South Texas. I've created a numerical report in excel using the autosum feature. I need to formulate a "High", "Medium", "Low" result. If the number is 33 or more this will be a "High."; 23-32 = "Medium"; 1-22 = "Low." Can you please help? Thank you. John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel displaying formulae as constant and not calculating formula | Excel Worksheet Functions | |||
How can i get an If formula in excel to edit another cell? | Excel Worksheet Functions | |||
converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula Integrity Not Preserved During Sort in Excel 2000 | Excel Discussion (Misc queries) |