Carrie has attended:
Excel Intermediate course
Excel Advanced course
Project Intermediate course
Positive, negative
How do I change a cell from a positive to negative number and vice versa?
RE: Positive, negative
Hi Carrie
Thank you for your question. Here are two ways to turn positive numbers negative (and vice versa)
using a formula
You can multiply the cell by -1
If the original number is negative you will get a positive answer. Positive values are converted to their negative equivalent.
If you always want a positive number (eg for percentages) use the ABS() function. This will return the positive value whether the source number is positive or negative.
=ABS(A1) will return 50 if A1 contains -50 or 50
I hope these ideas help - do let me know how you get on.
Kind regards,
Andrew
