Hi Eduardo,
In O16 it returns "False" if the value is zero. Is there a way to put 0
instead of False?

Thank you so much for your help, the formula worked!

"Eduardo" wrote:

Hi,
In cell O15 enter,
=if((N10+V10)80,80,N10+V10)

In cell O16 enter
=if((N10+V10)80,(N10+V10)-80)



"Abby" wrote:

Hello,
I need a formula that will do the following:

Add the sum of N10 and V10 up to 40. If N10 and/or V10 is over 40, I want
the difference to go to cell O16.
For example N10 = 42 and V10 = 43, I want 80 to go in cell O15 and 5 to go
in cell O16.

Can anyone help?

Thanks!