a formula combining 2 cells into a %
 

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

a formula combining 2 cells into a %
 

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.

a formula combining 2 cells into a %
 

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.

a formula combining 2 cells into a %
 

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.

a formula combining 2 cells into a %
 

Clarity !

a1 = 2.25
a2 = 5% ie 0.05
a3 = a1 * a2 ie 0.1125

Don't use "should equal cell 3" when you mean "you want the result in cell
3"

A3 is then a a value and *not* a percentage

But then again this may not be what you want :)

Steve


On Wed, 24 Jan 2007 23:43:02 -0000, 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.

a formula combining 2 cells into a %
 

Thanks for your help guys I got it figured out, thanks so much. Sorry for the
confusion in how i said things.

"Gord Dibben" wrote:

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.

a formula combining 2 cells into a %
 

Thanks for the feedback though

Steve

On Thu, 25 Jan 2007 17:11:02 -0000, not exceling
wrote:

Thanks for your help guys I got it figured out, thanks so much. Sorry
for the
confusion in how i said things.

"Gord Dibben" wrote:

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.