View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default 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