two formulas in one cell

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))