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