Multiple IF else formula not working.

[Arun]

Hello Gurus -

I am comparing the values of cell A1, and then i have to update the values of cell B1 accordingly -
If A1>13 B1=High
If A1<=12 or A1>=7 B1=Medium
If A1<=7 or A1>=0 B1 = Low

and i am using the following formula -

=IF(A1>=13,"High",IF(OR(A1<=12,A1>=7),"Medium",IF(OR(A1<=6,A1>=0),"Low")))

I am never getting the value as "Low" in column B-

I need to run this formula in whole cloumn A(A2,A3,A4 etc) and correspoindgly update the balues in column B(B2,B3,B4 etc).

kindly help me.
attached is the xls sheet.

[lenze]

Try

=IF((A1>=0)*A1<=6),"Low",IF(A1<=12,"Medium","High"))

lenze

[Bob Phillips]

=IF(A1>=13,"High",IF(A1>=7,"Medium",IF(A1>=0,"Low","")))