View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SteveW SteveW is offline
external usenet poster
 
Posts: 427
Default 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.