%

H

HARSHAWARDHAN. S .SHASTRI

Suppose a2 cell value is 100 and b2 cell value is 120 then write down
following formula in cell c2
= (b2-a2)*100/b2

Harshawardhan.Shastri

=============================================================
 
D

David Biddulph

In my book, that is a 20% increase, not a 16.67% increase. It would be more
conventional to divide by the *original* value, A2, rather than by B2.

Also, it is often more sensible not to multiply by 100 but merely to format
as percentage. That way, the percentage can be used in subsequent
calculations without having to divide by 100.

Hence, =(B2-A2)/A2 or =B2/A2-1
 
H

HARSHAWARDHAN. S .SHASTRI

You are correct.


==========================================================
 

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

Quick Parts and Formatting Question 1
Size of RTF increasing 10x after minor edit 0
Remove title bar and phase bar by default on swimlane 0
MS Project. Real progress of the project, % complete 1
Student & Home? 1
Make elements in a row space between instead of wrapping when choosing multiple columns 0
I need to place a rule between columns 0
Visio 2010 - Organization Chart Wizard - Hebrew Excel Database 0

Top