I'm confused now.

5% of 2.25 is =A1*.05 which returns .1125

Is this what you want?


Gord


On Wed, 24 Jan 2007 15:43:02 -0800, not exceling
wrote:

Thanks for the response Gord, my problem is 2.25 in cell 1 5% in cell 2 which
should equal cell 3 as a percentage. I'm looking for 5% of 2.25.

"Gord Dibben" wrote:

A1 is 56

A2 is 200

In A3 enter =A1/A2 which returns 28% when formatted as Percentage.


Gord Dibben MS Excel MVP



On Wed, 24 Jan 2007 13:46:00 -0800, not exceling <not
wrote:

I need to create a formula that takes 2 cells with numbers and in the 3rd
cell gives a % of the 2.