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

=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

"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