IF then statement question
Try something like:
=IF(A1<500,B1,C1)
or
=IF(A1<500,B1,IF(A1500,D1,0))
if A1 = 500 then this formula will return 0, adjust to suit!
HTH
Jean-Guy
"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
|