Another Extremely complex IF statement
 

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

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

Another Extremely complex IF statement
 

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

"Ron Coderre" wrote:

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