| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
-sign
I have5 columns a b c d e
I would like a formula to work out and show a minus sign if the total of cell d is greater than the total of cell a, if cell d is greater that cell a just the difference, ie a100 a10 d101 d 9 e -1 e 1 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
-sign
=A1-D1
Vaya con Dios, Chuck, CABGx3 "bbc1" wrote: I have5 columns a b c d e I would like a formula to work out and show a minus sign if the total of cell d is greater than the total of cell a, if cell d is greater that cell a just the difference, ie a100 a10 d101 d 9 e -1 e 1 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
-sign
In E1 try
=SIGN(A1-D1) If this post helps click Yes --------------- Jacob Skaria "bbc1" wrote: I have5 columns a b c d e I would like a formula to work out and show a minus sign if the total of cell d is greater than the total of cell a, if cell d is greater that cell a just the difference, ie a100 a10 d101 d 9 e -1 e 1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can i change dollar sign to rupee sign in sales invoice | Excel Discussion (Misc queries) | |||
| Why a plus sign after the equal sign? | Excel Discussion (Misc queries) | |||
| can I change the $ sign to a £ sign in an MS template? | Excel Worksheet Functions | |||
| XL invoice replace the dollar sign with euro sign | New Users to Excel | |||
| -ve no with -1; positive with sign+ and 0 no sign? Tks. | Excel Worksheet Functions | |||
Hybrid Mode
