Finding the right percentage formula

**Papa Pro** · 10-06-2007, 01:27 PM

Hi all,

I need help with this simple formula. Below are how my cells look. The success rate cell is the one I am having problems with.

Orders cell (F10) = 100

Sales cell (B10) = 90

Success rate = 90% (This is the formula I need) it says 9600.00% on my Success Rate Cell and this is the formula I tried. =AVERAGE(F10,B10) I want this cell to read 90% so need that fomula.

Hope I expressed this correctly.

Cheers,

Richard

**VBA Noob** · 10-06-2007, 01:38 PM

Is this what you need

=B10/F10

format cell as % with no decimals

VBA Noob

**Papa Pro** · 10-06-2007, 02:11 PM

Thanks so much for the response. But no my friend. That does not seem to be the one I need. I will try and explain better as I am quite new to Exel 2007.

I formatted my colum with the % feature to 0. It this colum I want to be the success rate colum measuring Colums "F" being my "orders" colum and colum B being my sales colum. I am using colum I for my perfomance data but it needs to read in 100%. So that my perfomance comum (Colum I) can show me what the pecentage on sales are on that product. If we sell 90 of 100 units. Then the I colum should read “90%” for that paticular product (in the I colum cell).

So what I need is the formular for colum I cells. Colum I will be linked to the corosponding data in colums F & B. I feel I am over complicating things and getting completely lost. So if anyone can help then I would apreciate it. Hope someone understands what mean.

Big thanks,

Richard

**protonLeah** · 10-06-2007, 03:50 PM

VBA Noob's formula is correct. You should have put it in column I and formatted column I as percent with 0 decimals. You cannot use the AVERAGE function because, for your example, it says that you had two salesmen, one of whom sold 100 units, and the other sold 90 units giving an average sale of 96 units per man.

**Papa Pro** · 10-06-2007, 04:05 PM

Thanks ben and all, this place is a great resorce.

That formula worked on the first cell but when I special pasted that formula into the rest of the colum, the % went above 100%?

Can I post my sheet for somone to take a quick look? I would aprecuate it. I want nice 3D charts too but need to get the formulas right first. Or can e-mail it?

Cheers,

Richard

Btw, How do you upload a sheet?