Need formula to cal percentage of 2 numbers

Hi,

I would like the formula that will compare two numbers and give me the
percentage in the third column.

ex C4 compared to B4 put in cloumn D4 as a percentage,

New to excel and need to know how to put the formula in the cell too?
thanks for hel p in advance
--
Mike B

=C4/B4 and format as percentage

--
HTH

Bob Phillips

"mike b" <[email protected]> wrote in message
news:[email protected]...
> Hi,
>
> I would like the formula that will compare two numbers and give me the
> percentage in the third column.
>
> ex C4 compared to B4 put in cloumn D4 as a percentage,
>
> New to excel and need to know how to put the formula in the cell too?
> thanks for hel p in advance
> --
> Mike B

Hi Mike
In D4 type:
=(C4-B4)/B4
and format your cell as percentage

HTH
Cordially
Pascal

"mike b" <[email protected]> a écrit dans le message de news:
[email protected]...
> Hi,
>
> I would like the formula that will compare two numbers and give me the
> percentage in the third column.
>
> ex C4 compared to B4 put in cloumn D4 as a percentage,
>
> New to excel and need to know how to put the formula in the cell too?
> thanks for hel p in advance
> --
> Mike B

mike b wrote:
|| Hi,
||
|| I would like the formula that will compare two numbers and give me
|| the percentage in the third column.
||
|| ex C4 compared to B4 put in cloumn D4 as a percentage,
||
|| New to excel and need to know how to put the formula in the cell too?
|| thanks for hel p in advance
|| --
|| Mike B

Suggest you get down to your local book store and buy "Excel for Dummies"

--
Gordon Burgess-Parker
Interim Systems and Management Accounting
www.gbpcomputing.co.uk