Percent of Increase...Is there such a formula?
 

Is there such a formula that would allow me to determine the percent of
increase from say cells B3 to C3 given these cells have numerical figures in
them?

Percent of Increase...Is there such a formula?
 

=(C3-B3)/B3
Format as %

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Shayra" wrote in message ...
| Is there such a formula that would allow me to determine the percent of
| increase from say cells B3 to C3 given these cells have numerical figures in
| them?

Percent of Increase...Is there such a formula?
 

=(C3-B3)/B3 and format as percentage
--
Gary''s Student - gsnu200785


"Shayra" wrote:

Is there such a formula that would allow me to determine the percent of
increase from say cells B3 to C3 given these cells have numerical figures in
them?

Percent of Increase...Is there such a formula?
 

=C3/B3-1 or =(C3-B3)/B3
In either case, format the result as a percentage.
--
David Biddulph

"Shayra" wrote in message
...
Is there such a formula that would allow me to determine the percent of
increase from say cells B3 to C3 given these cells have numerical figures
in
them?

Percent of Increase...Is there such a formula?
 

With 10 in B3 and 12 in C3

In D3 enter =(C3-B3)/B3 to return 20% increase


Gord Dibben MS Excel MVP

On Tue, 13 May 2008 08:51:01 -0700, Shayra
wrote:

Is there such a formula that would allow me to determine the percent of
increase from say cells B3 to C3 given these cells have numerical figures in
them?