Forum Discussion

erin-5304's avatar
erin-5304
Brass Contributor
Feb 27, 2023

Multiple If's

I have a multiple if formula I can't make work.  Here is what it is for:

 

If E18="Flat Rate" then Sum (K43:K46)

 

If E18 has a number greater than 0, then Sum (K43:K46), but if the total is less than $6000, it should equal $6000.

 

I am trying this but it is not working....

 

=IF(AND(E18="Flat Rate",SUM(K43:K46),IF(AND(E18>0,SUM(K43:K46)<6000,6000))))

 

 

  • erin-5304 

    =IF(E18="Flat Rate",SUM(K43:K46),IF(E18>0,MAX(SUM(K43:K46),6000),""))

     

    Does this formula return the expected result?

     

    For example:

     

    Or:

  • erin-5304 

    =IF(E18="Flat Rate",SUM(K43:K46),IF(E18>0,MAX(SUM(K43:K46),6000),""))

     

    Does this formula return the expected result?

     

    For example:

     

    Or:

Resources