skaswani

11-09-2007, 07:40 AM

Hello

i want to make a condition in Worksheet , it should be on blow logic

if a1 is between 1 to 30 then a1 should be place in a2

if a1 is between 31 to 60 then a1 should be place in a3

if a1 is between 61 to 90 then a1 should be place in a4

if a1 is between 91 to 180 then a1 should be place in a5

if a1 is between 181 to 360 then a1 should be place in a6

if a1 is between 361 to 720 then a1 should be place in a7

.....

.

.

.

.

.

..

i read that IF() allows upto 7 conditions, i may need more then 7 conditions

please kindly help me thanks

i want to make a condition in Worksheet , it should be on blow logic

if a1 is between 1 to 30 then a1 should be place in a2

if a1 is between 31 to 60 then a1 should be place in a3

if a1 is between 61 to 90 then a1 should be place in a4

if a1 is between 91 to 180 then a1 should be place in a5

if a1 is between 181 to 360 then a1 should be place in a6

if a1 is between 361 to 720 then a1 should be place in a7

.....

.

.

.

.

.

..

i read that IF() allows upto 7 conditions, i may need more then 7 conditions

please kindly help me thanks