Arun
03-30-2009, 11:59 AM
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.
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.