Another Extremely complex IF statement
Try this:
=IF(I53*363<D53,MAX(D53*0.2617,C10),MAX(I53*D10,C1 0))
Does that help?
***********
Regards,
Ron
XL2002, WinXP
"Teri" wrote:
How would this be written as a formula?
If I53 X 363 is less than D53, then D53 X .2617 is the value, except, when
D53 X .2617 is less than C10 than the value should be C10. Otherwise, the
value should be D53 X .2617. However, if I53 X 363 is greater than D53,
then I53 X D10 is the value, except, when I53 X D10 is less than C10, then
the value should be C10. Otherwise, the value should be I53 X D10
|