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.

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.

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.