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