Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to round negative and positive numbers | Excel Worksheet Functions | |||
displaying letters as average instead of numbers | Excel Discussion (Misc queries) | |||
convert negative numbers to positive numbers and vice versa | Excel Worksheet Functions | |||
how do I rank negative and positive numbers? | Excel Worksheet Functions | |||
In excel, column headings displaying as numbers | Excel Discussion (Misc queries) |