ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Displaying all numbers as positive (https://www.excelbanter.com/excel-worksheet-functions/111100-displaying-all-numbers-positive.html)

TeddyTash

Displaying all numbers as positive
 
Ok hope you guys can help:

A1= x
A2= y
A3= A1-A2

If the answer is a positive number I want it to remain as a positive number
-but-
If the answer is a negative number, I wish for it to be displayed without the "-" sign before the number so it looks like it's a positive number. But I also want it to hold it's negative value so that it can be used later on.

Example:
A1= 5
A2= 8
A3= A1-A2

A3 Normally displays "-3", I want it to display "3".

But I also need it so that if I make A4=A3, then A4 will display "-3"

Hope this makes sense to someone!


Thanks in advance,
Teddy


All times are GMT +1. The time now is 09:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com