sum up to maximum value

Good evening. I am relatively new to excel formulas and looking to understand how to get what is in my head into a workable formula.

1. THE ISSUE
The values in the "N" column represent the actual value that was entered.
The values in the "O" column represent how much those values are increasing.

The value in "P" is obviously the SUM of "N" and "O", which is fine, until it goes over the number "10" which I would like to set as a metaphorical "threshold".

2. WHAT I WANT THE FORMULA TO SAY (I think)

IF "P" exceeds "10.00," then round down to "10.00"

OR

IF "P" exceeds "10.00," then display "10.00"

I DO NOT want it to affect any other values, only the "P" column

How would I write this?
Thanks!

123.PNG

Hi, welcome to the forum.

Please take a few minutes to read our rules, specifically regarding thread titles - they need to explain what you are trying to do. ( have changed it for you - this time)

For what you are doing, you need to use the MIN function....
=MIN(N1+O1,10)

No problem, happy to help