Hi very one
I am new to excel so please help me out for following
If the value cell A1 is 1 to 5 then value in cell B1 shall be 1,If the value in cell A1 is 6 to 15 then the value in cell B1 shall be 2, I the value in cell A1 is 16 to 30 than value in cell B1 shall be 3, If the value in cell A1 is 31 to 50 than the value in cell B1 shall be 4, if the value in cell A1 is 51 to 100 than the value in cell B1 shall be 5, If the value in cell A1 is greater than 100 then value in cell B1 shall be 6
Seems very complicated to me so please help me out
Regards
Jagan
I am new to excel so please help me out for following
If the value cell A1 is 1 to 5 then value in cell B1 shall be 1,If the value in cell A1 is 6 to 15 then the value in cell B1 shall be 2, I the value in cell A1 is 16 to 30 than value in cell B1 shall be 3, If the value in cell A1 is 31 to 50 than the value in cell B1 shall be 4, if the value in cell A1 is 51 to 100 than the value in cell B1 shall be 5, If the value in cell A1 is greater than 100 then value in cell B1 shall be 6
Seems very complicated to me so please help me out
Regards
Jagan