Another Extremely complex IF statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Try this:

=IF(I53*363<D53,MAX(D53*0.2617,C10),MAX(I53*D10,C10))

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
Ron, I'm going to run this by my boss, but I've been so confounded by this
problem! Thank you for helping me !!

Teri
 
Back
Top