| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I write a formula if b2 is less than a2 then subtract
I'm looking for a formula that says if b2 is less than a2 then subtract but
if greater than then add Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I write a formula if b2 is less than a2 then subtract
Try:
=IF(B2<A2,A2-B2,A2+B2) although you didn't specify what to do when A2=B2. this formula would add A2 and B2 when they are equal. "delete automatically" wrote: I'm looking for a formula that says if b2 is less than a2 then subtract but if greater than then add Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I write a formula if b2 is less than a2 then subtract
Not sure I understand but ...
=IF(A2B2,A2-B2,A2+B2) Regards Trevor "delete automatically" wrote in message ... I'm looking for a formula that says if b2 is less than a2 then subtract but if greater than then add Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I write a formula if b2 is less than a2 then subtract
I'm looking for a formula that says if b2 is less than a2 then subtract
Ok, subtract what? B2 from A2? Also, you didn't say what to do if A2 = B2. =IF(B2<A2,A2-B2,A2+B2) If A2 = B2 they will be added. -- Biff Microsoft Excel MVP "delete automatically" wrote in message ... I'm looking for a formula that says if b2 is less than a2 then subtract but if greater than then add Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I write a fromula to subtract 1/4 from 1/2 and so on? | Excel Discussion (Misc queries) | |||
| formula to subtract time, 12:10 am (00:10) - 11:50 pm (23:10) ? | New Users to Excel | |||
| I would like to know how to enter the formula that would subtract. | Excel Worksheet Functions | |||
| How do I create a formula that would allow me to subtract from a d | New Users to Excel | |||
| How do I write a formula to subtract a # from a total ONLY if the. | Excel Worksheet Functions | |||
Linear Mode
