| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
