| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If statement; How to do something similar to - if(a1-a2=5,+5)
If Sum of two cells is Greater than or equal to 5 then +0.5 If not
then normal sum. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
If statement; How to do something similar to - if(a1-a2=5,+5)
=IF(A1+B1=5,.05,0) or maybe you are looking for something like. You didn't say =a2+IF(A1+B1=5,.05,0) =123+IF(A1+B1=5,.05,0) Don Guillett SalesAid Software "Magoo" wrote in message oups.com... If Sum of two cells is Greater than or equal to 5 then +0.5 If not then normal sum. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
If statement; How to do something similar to - if(a1-a2=5,+5)
On May 25, 10:27 am, "Don Guillett" wrote:
=IF(A1+B1=5,.05,0) or maybe you are looking for something like. You didn't say =a2+IF(A1+B1=5,.05,0) =123+IF(A1+B1=5,.05,0) Don Guillett SalesAid Software "Magoo" wrote in message oups.com... If Sum of two cells is Greater than or equal to 5 then +0.5 If not then normal sum.- Hide quoted text - - Show quoted text - Don, What I would like to do is have the Cell be the Sum of a1-a2 but with a twist. If the sum is Less than or equal to 5, I would like to add 0.5 and have that show up in the cell. If the sum is Greater than that I just want the normal result. for instance; a1=40 a2=35 The difference of these would normally be 5. But I would like the formula to add an additional 0.5 to that figure making it 5.5. on the other hand if; a1=40 a2=32 The difference would be 8. At this point would not need to add the additional 0.5. So the Cell's Contents would remain 8. I hope this makes sense... Thanks for your Help! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
If statement; How to do something similar to - if(a1-a2=5,+5)
A1-A2 is a difference, not a sum, which confused us. Also it wasn't clear
what you meant by +5 or +0.5. Try this: =A1-A2+IF(A1-A2<=5,0.5,0) - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Magoo" wrote in message oups.com... On May 25, 10:27 am, "Don Guillett" wrote: =IF(A1+B1=5,.05,0) or maybe you are looking for something like. You didn't say =a2+IF(A1+B1=5,.05,0) =123+IF(A1+B1=5,.05,0) Don Guillett SalesAid Software "Magoo" wrote in message oups.com... If Sum of two cells is Greater than or equal to 5 then +0.5 If not then normal sum.- Hide quoted text - - Show quoted text - Don, What I would like to do is have the Cell be the Sum of a1-a2 but with a twist. If the sum is Less than or equal to 5, I would like to add 0.5 and have that show up in the cell. If the sum is Greater than that I just want the normal result. for instance; a1=40 a2=35 The difference of these would normally be 5. But I would like the formula to add an additional 0.5 to that figure making it 5.5. on the other hand if; a1=40 a2=32 The difference would be 8. At this point would not need to add the additional 0.5. So the Cell's Contents would remain 8. I hope this makes sense... Thanks for your Help! |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
If statement; How to do something similar to - if(a1-a2=5,+5)
=IF(A1+B1<=5,A1+B1+.05,A1+B1)
"Magoo" wrote: On May 25, 10:27 am, "Don Guillett" wrote: =IF(A1+B1=5,.05,0) or maybe you are looking for something like. You didn't say =a2+IF(A1+B1=5,.05,0) =123+IF(A1+B1=5,.05,0) Don Guillett SalesAid Software "Magoo" wrote in message oups.com... If Sum of two cells is Greater than or equal to 5 then +0.5 If not then normal sum.- Hide quoted text - - Show quoted text - Don, What I would like to do is have the Cell be the Sum of a1-a2 but with a twist. If the sum is Less than or equal to 5, I would like to add 0.5 and have that show up in the cell. If the sum is Greater than that I just want the normal result. for instance; a1=40 a2=35 The difference of these would normally be 5. But I would like the formula to add an additional 0.5 to that figure making it 5.5. on the other hand if; a1=40 a2=32 The difference would be 8. At this point would not need to add the additional 0.5. So the Cell's Contents would remain 8. I hope this makes sense... Thanks for your Help! |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
If statement; How to do something similar to - if(a1-a2=5,+5)
Sorry, you wanted that for the difference, didn't you.
=IF(A1-B1=5,A1-B1+.05,A1-B1) "Magoo" wrote: On May 25, 10:27 am, "Don Guillett" wrote: =IF(A1+B1=5,.05,0) or maybe you are looking for something like. You didn't say =a2+IF(A1+B1=5,.05,0) =123+IF(A1+B1=5,.05,0) Don Guillett SalesAid Software "Magoo" wrote in message oups.com... If Sum of two cells is Greater than or equal to 5 then +0.5 If not then normal sum.- Hide quoted text - - Show quoted text - Don, What I would like to do is have the Cell be the Sum of a1-a2 but with a twist. If the sum is Less than or equal to 5, I would like to add 0.5 and have that show up in the cell. If the sum is Greater than that I just want the normal result. for instance; a1=40 a2=35 The difference of these would normally be 5. But I would like the formula to add an additional 0.5 to that figure making it 5.5. on the other hand if; a1=40 a2=32 The difference would be 8. At this point would not need to add the additional 0.5. So the Cell's Contents would remain 8. I hope this makes sense... Thanks for your Help! |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
If statement; How to do something similar to - if(a1-a2=5,+5)
On May 25, 12:51 pm, JLGWhiz
wrote: Sorry, you wanted that for the difference, didn't you. =IF(A1-B1=5,A1-B1+.05,A1-B1) "Magoo" wrote: On May 25, 10:27 am, "Don Guillett" wrote: =IF(A1+B1=5,.05,0) or maybe you are looking for something like. You didn't say =a2+IF(A1+B1=5,.05,0) =123+IF(A1+B1=5,.05,0) Don Guillett SalesAid Software "Magoo" wrote in message roups.com... If Sum of two cells is Greater than or equal to 5 then +0.5 If not then normal sum.- Hide quoted text - - Show quoted text - Don, What I would like to do is have the Cell be the Sum of a1-a2 but with a twist. If the sum is Less than or equal to 5, I would like to add 0.5 and have that show up in the cell. If the sum is Greater than that I just want the normal result. for instance; a1=40 a2=35 The difference of these would normally be 5. But I would like the formula to add an additional 0.5 to that figure making it 5.5. on the other hand if; a1=40 a2=32 The difference would be 8. At this point would not need to add the additional 0.5. So the Cell's Contents would remain 8. I hope this makes sense... Thanks for your Help!- Hide quoted text - - Show quoted text - JLGWhiz thank you. This is exactly what I wanted. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reconcile Bank statement & Credit card statement & accounting data | Excel Worksheet Functions | |||
| if statement or other methds to find similar data | Excel Worksheet Functions | |||
| SQL REPLACE Statement (or similar) in MS Query | Excel Programming | |||
| how to create automatic macro with if statement or similar | Excel Discussion (Misc queries) | |||
|
IF statement with logical_value that is similar to this 0 |
Excel Worksheet Functions | |||
Linear Mode
