convert values positive to negative and negative to positive

[arulsettu]

Hi,

      i am having a pivot table  with positive and negative values. i want to convert the values negative to positive and positve to negative.

one of community friend said mupliply by -1. but the problem is i am having multiple if conditions so i am unable to write the condition

anyone please can guide me how to do it

Thanks

[Gysbert_Wassenaar · Accepted solution]

You have an expression now. But parenthesis around the entire expression and put a - in front of it. If your expression starts with an = character then put that outside the parentheses, i.e. = -( ...complicated_expression_here ...) instead of -=( ...complicated_expression_here ...) or -(= ...complicated_expression_here ...). The last two are wrong.

[arulsettu]

Thank you very much