Multiple if statements I think

[Guest]

I think this problem would be best solved by an IF statement. I need to write
a formula that will format a cell or return a value (1 or 0) if cell a1 is
less than 500 and d1 is greater than 2% ;also if cell a1 happens to be
between 501-999 and cell d1 is greater than 1%; also if cell a1 is greater
than 1000 and cell d1 is greater than 0%. I hope I have explained my problem
properly.

 

[David Biddulph]

=IF(OR(AND(A1<500,D1>2%),AND(A1>=501,A1<=999,D1>1%),AND(A1>1000,D1>0)),1,0)
?
Or (if I guess at some of your undefined ranges)
=IF(D1>1%*((A1<1000)+(A1<500)),1,0)

 

[Don Guillett]

try looking in the help index for AND to mix wit OR
=if(or(and(a1<500,d1>2%),other or