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.