What formula would I use to get -2 / -2 = -100%

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

Guest

I need to know how do I divide two negative numbers to come out with a
negative percentage?

In other words.....-2 / -4 = -50%
 
Well, math doesn't really work that way; a negative divided by a negative
yields a positive. If you want the opposite, you simply divide one negative
number by the other, then multiply by -1

=-2/-4*-1
 
I'm struggling to find any reason you'd want it to be negative, but...

Since you know 2 negatives make a positive you just have to add in another
negative sign to change it back to negative, i.e. =-(-2/-4)

What about -2/4 (aka negative 2 divided by POSITIVE 4), what then? Is that
going to be positive?!!?
 
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

How do I create the formula for this calculation? 1
What formula would I use? 2
Extract the 2 Lowest % 3
Validation of UK VAT Number 20
I have a worksheet 1
Custom Cell Formatting Using % With Dates 2
Combining two formulas 4
% Variance 5

Back
Top