| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Non-signed Difference between 2 cells
rather than having to code:
=IF(A1-B1<0,(A1-B1)*-1,(A1-B1)) or applying special formating to the cell to suppress the "-" sign, Surely there must be a worksheet built-in function to give me the difference between two cells. Can anyone help? Thanks a mil Cherft |
|
#2
|
|||
|
|||
|
Hi cherft,
rather than having to code: =IF(A1-B1<0,(A1-B1)*-1,(A1-B1)) =abs(a1-b1) arno |
|
#3
|
|||
|
|||
|
One way:
=ABS(A1-B1) In article , cherft wrote: rather than having to code: =IF(A1-B1<0,(A1-B1)*-1,(A1-B1)) or applying special formating to the cell to suppress the "-" sign, Surely there must be a worksheet built-in function to give me the difference between two cells. |
|
#4
|
|||
|
|||
|
=ABS(A1-B1)
- Mangesh "cherft" wrote in message ... rather than having to code: =IF(A1-B1<0,(A1-B1)*-1,(A1-B1)) or applying special formating to the cell to suppress the "-" sign, Surely there must be a worksheet built-in function to give me the difference between two cells. Can anyone help? Thanks a mil Cherft |
|
#5
|
|||
|
|||
|
Many thanks indeed - appreciated
regards Cherft "arno" wrote: Hi cherft, rather than having to code: =IF(A1-B1<0,(A1-B1)*-1,(A1-B1)) =abs(a1-b1) arno |
|
#6
|
|||
|
|||
|
Many thanks indeed - appreciated
regards Cherft "JE McGimpsey" wrote: One way: =ABS(A1-B1) In article , cherft wrote: rather than having to code: =IF(A1-B1<0,(A1-B1)*-1,(A1-B1)) or applying special formating to the cell to suppress the "-" sign, Surely there must be a worksheet built-in function to give me the difference between two cells. |
|
#7
|
|||
|
|||
|
Many thanks indeed - appreciated
regards Cherft "Mangesh" wrote: =ABS(A1-B1) - Mangesh "cherft" wrote in message ... rather than having to code: =IF(A1-B1<0,(A1-B1)*-1,(A1-B1)) or applying special formating to the cell to suppress the "-" sign, Surely there must be a worksheet built-in function to give me the difference between two cells. Can anyone help? Thanks a mil Cherft |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want to select excel cells of difference colors and increase th. | Excel Worksheet Functions | |||
| Calculating the difference between cells | Excel Worksheet Functions | |||
| Help adding text values | Excel Worksheet Functions | |||
| To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
| sum difference cells on multiple sheets | Excel Worksheet Functions | |||
Linear Mode
