IF formula
 

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!

IF formula
 

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!

IF formula
 

What if:

N10 = 42 and V10 = 30

What should the results be for:

O15 ?
O16 ?

--
Biff
Microsoft Excel MVP


"Abby" wrote in message
...
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!

IF formula
 

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!

IF formula
 

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


"Abby" wrote:

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!

IF formula
 

Thanks so much for your help!

"Eduardo" wrote:

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


"Abby" wrote:

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!