Negative numbers in easy formula getting me down...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm using a formula to calculate the % increase or decrease of some numbers.
My formula is =(H33-N33)/N33. However, I have a negative number N33 so the %
should be a positive because there was an increase but it's coming out a
negative. Why isn't this calculating N33 as a negative number?
 
You can multiply your result by a -1 to insure that it's positive.

=((H33-N33)/N33)*-1

or

=IF((H33-N33)/N33<0,((H33-N33)/N33)*-1,=(H33-N33)/N33)
 
jennieoh said:
I'm using a formula to calculate the % increase or decrease of some
numbers.
My formula is =(H33-N33)/N33. However, I have a negative number N33 so
the %
should be a positive because there was an increase but it's coming out a
negative. Why isn't this calculating N33 as a negative number?
Click to expand...

You could use =(H33-N33)/ABS(N33), but bear in mind the possibility of N33
being zero (in which case you'd need to think about what % increase you'd
want to show there).
 
how about

=(H33-N33)/abs(N33)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
You must log in or register to reply here.

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

Negative Numbers 8
ignoring negative numbers 4
Adding only negative numbers in row 3
Subtotal data excluding negitive numbers. 3
Change negative nmbr to positive 7
Negative Numbers Have Positive Result 4
Delete all negative numbers leaving only positive numbers 8
Negative Numbers in Brackets 2

Back
Top