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?

=(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?

=(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?

=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?

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?