two formulas in one cell

hello this is an easy one for someone. sorry in advance but I tried searching but I think my IT Dept blocked something because it just gives me a blank screen when I try.

I need a cell to 1st add 2 cells together, then if the sum of that is greater than 18.50 it changes it to 18.50. (18.50 is the salery cap).

thank you!

=IF(SUM(C20:D20)>18.5,18.5,SUM(C20:D20))

if the sum if greater than 18.5, value is 18.5, otherwise, the sum of the two values

this is only resulting in 18.50 no matter what

here is the spreadsheet

formula needs to be

HTML Code: 

change ":" to ",".
You don't want to add the range, only the two cells J15 and Q15.

see the attached file.
modytrane

thank you!!!

or An alternative - it may be more simple:

=MIN(18.5,SUM(J15,Q15))

i just ran into another issue. If the sum = zero it needs to stay @ zero.

change the format to currency

see attached.
I modified the formula.
it works
modytrane

Originally Posted by modytrane

see attached.

I think the fomula
=IF(SUM(J15,Q15)>18.5,18.5,IF(SUM(J15,Q15)=0,0,SUM(J15,Q15)))
is the same as
=IF(SUM(J15,Q15)>18.5,18.5,SUM(J15,Q15))

and the result also like as the another formula
=MIN(18.5,SUM(J15,Q15))