incorrect value in formula

G

Guest

I am trying to do a percentage change fromm 10,000 to 8000 at year end. It
should be 20% decrease. I don't know if I am doing incorrect formula but
when I try to do: 8000-1000, I get a value of -300000.0%. Why is that? What
is the correct formula?
 
J

Jerry W. Lewis

The decrease is 2,000 (10,000-8,000), not 7000=8000-1000. As a percent
of initial value, that would be 2000/10000 formatted as %.

Jerry
 

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

Top