Easy Excel Formula

S

Skydiver

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
 
C

CLR

=IF(A1>=33,"High",IF(A1>22,"Medium",IF(A1>=1,"Low","")))

Vaya con Dios,
Chuck, CABGx3
 
S

Skydiver

"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.
 
Top