| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I always display numbers produced from subtractionas posit
How do I display, say "1000 minus 2000" as "1000" Instead of "-1000". However
if the two numbers entered were then changed to say, "2000 minus 1000" it would STILL produce the answer "1000" - again, a positive number. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I always display numbers produced from subtractionas posit
Hi,
=ABS(b1-a1) Mike "Brijay" wrote: How do I display, say "1000 minus 2000" as "1000" Instead of "-1000". However if the two numbers entered were then changed to say, "2000 minus 1000" it would STILL produce the answer "1000" - again, a positive number. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I always display numbers produced from subtractionasposit
=ABS(1000-2000)
assume A1 = 2000, B1 = 1000 =ABS(B1-A1) On Oct 22, 7:00*pm, Brijay wrote: How do I display, say "1000 minus 2000" as "1000" Instead of "-1000". However if the two numbers entered were then changed to say, "2000 minus 1000" it would STILL produce the answer "1000" - again, a positive number. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| extract data frm files produced from templates | Excel Discussion (Misc queries) | |||
| Specific Data Ranges Produced From Drop Down Lists | Excel Worksheet Functions | |||
| display/not display numbers to right of decimal | Excel Discussion (Misc queries) | |||
| Numbers display as decimal, i.e. enter 123 display 1.23 | Setting up and Configuration of Excel | |||
| display the cell that produced a result | Excel Discussion (Misc queries) | |||
Linear Mode
