Yet another extremely complex IF statement
 

How can this be written as a formula?

If I53 X 363 is less than D53, then D53 X .0688 is the value, except, when
D53 X .0688 is less than B24 then the value should be B24. Otherwise, the
value should be D53 X .0688. However, if I53 X 363 is greater than D53, then
I53 X D24 is the value, except, when I53 X D24 is less than B24, then the
value should be B24. Otherwise, the value should be I53 X D24.

Yet another extremely complex IF statement
 

Try this:

=IF(I53*363<D53,MAX(D53*0.0688,B24),MAX(I53*D24,B2 4))

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

XL2002, WinXP


"Teri" wrote:

How can this be written as a formula?

If I53 X 363 is less than D53, then D53 X .0688 is the value, except, when
D53 X .0688 is less than B24 then the value should be B24. Otherwise, the
value should be D53 X .0688. However, if I53 X 363 is greater than D53, then
I53 X D24 is the value, except, when I53 X D24 is less than B24, then the
value should be B24. Otherwise, the value should be I53 X D24.