Use two IFs, one to check if A1<500 and the other to check if A1500. Type in
cell D1:

=IF(A1<500, B1, IF(A1500, C1, "A1=500"))

Note that if A1 = 500 the formula will show "A1=500" because you didn't tell
what to do if A1=500. If you say that if A1 is less than or equal to 500,
D1=B1 then the formula is simpler:

=IF(A1<=500, B1, C1)

--
Rogerio Takejame
Americana - Sao Paulo - Brazil


"ChuckW" wrote:

Hi,

I have four cells of data (A1 through D1). I have created an If then
statement where If A1 is less than 500, D1 = B1. I also want to have it so
that If A1 500 then D1=C1. How would I write a formula for this. Can
anyone help?

Thanks


--
Chuck W