PDA

View Full Version : Solved: condition



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

Bob Phillips
11-09-2007, 07:44 AM
You misunderstand, as the formulae would be in A2, A3, etc.

A2: =IF(A1<31,A1,"")
A3: =IF(AND(A1>30,A1<61),A1,"")
A4: =IF(AND(A1>60,A1<91),A1,"")

etc.

skaswani
11-09-2007, 07:58 AM
dam..
its so simple

i dont know why i was using If with Or :(
thanks