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

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

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