IF formula

[Abby]

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!

 

[Abby]

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]

Hi Abby,
Use
In cell O16 enter
=if((N10+V10)>80,(N10+V10)-80,0)

 

[Abby]

Thanks so much for your help!

Hi Abby,
Use
In cell O16 enter
=if((N10+V10)>80,(N10+V10)-80,0)