| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I Create a formula for greater or lesserthen
How do I IF A1C1 subtract A1 from C1 but IF A1<C1 subtract C1 from A1
A1 B1 C1 Toatal 15 30 15 A1 B1 C1 Total 30 15 30 I'm looking for the difference between one cell and another... Hope this make sense. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I Create a formula for greater or lesserthen
=ABS(A1-C1)
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Put PPT to bed" wrote in message ... How do I IF A1C1 subtract A1 from C1 but IF A1<C1 subtract C1 from A1 A1 B1 C1 Toatal 15 30 15 A1 B1 C1 Total 30 15 30 I'm looking for the difference between one cell and another... Hope this make sense. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create an increase or decrease formula with zero % | Excel Worksheet Functions | |||
| How do I create a formula by percentage within a formula? | Excel Worksheet Functions | |||
| Match then lookup | Excel Worksheet Functions | |||
| How do I create a 26 'tier' IF formula? | Excel Discussion (Misc queries) | |||
| How to create specific formula | Excel Worksheet Functions | |||
Linear Mode
