Change negative to positive numbers and vice versa

nfoong

Hi, I have a table below:

Profit	-100
Operating Cost	20
Taxes	20
Net Profit	-60

I need to change all negative numbers to positive and vice versa.

What's the quickest way to do it? I have an odd situation, whereby costs is shown as positive and revenue as negative....

MarqueeCrew

@nfoong,

Your sample data didn't have a field name.  When using the formula tool, select the field that has that "value" in it and use the formula where you replace [Value] with the actual field name.  In the following example, let's say that the field name is "Amount".

[Amount] * -1

That's how to change a value from positive to negative or negative to positive.

Cheers,

Mark