Opposite of ABS?

G

Guest

Hi

I have positive numbers on Credit Notes that I want to treat as negatives
when running total income report. I can do it using a formula i.e. 20/20-1-20
will change 20 to -20, but wondered if there is a reverse of the ABS
function that will do it for me. Thanks

Sheila
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ABS formula help please 4
Report Ignoring negative numbers 7
Abs Function 3
is there a function that does this? 1
Access formulas 2
Array formula difficulty 10
Countif or Sumif with frequency 4
finding 10 smallest numbers from last 20 input 8

Top