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.

=IF(OR(AND(A1<500,D12%),AND(A1=501,A1<=999,D11% ),AND(A11000,D10)),1,0)
?
Or (if I guess at some of your undefined ranges)
=IF(D11%*((A1<1000)+(A1<500)),1,0)
--
David Biddulph

"DP7" wrote in message
...
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.

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

--
Don Guillett
SalesAid Software

"DP7" wrote in message
...
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.