now I have that working trying another formula

I have two cell working with previous formula with the 2 amounts capped.

I then want a total of the 2 amounts but if both cells have been capped I want the cap figure and not the SUM of the 2 cells.

I currently have this =SUM(T9,W9) and tried this =SUM(T9,W9,J9) but with this it caps all and doesn't add the 2 cells when needed.

any ideas please


Edit mod : this post is related to https://www.msofficeforums.com/excel...l-formula.html