IF formula

  • Thread starter Thread starter Abby
  • Start date Start date
A

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!
 
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!
 
Back
Top