Forum Discussion
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...
=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:
=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:
Yep, works perfect! Thank you!