I am hoping some genius out there can help me with a formula.
I want to do this€¦. First cell has total sales of 10,000, Second sell has
fees of 100. I want the 3rd cell to tell me what percentage of the total
sales are going toward fees.
Anyone know? It would be appreciated if you could tell me what formula to
put in the 3rd cell.
Thanks rob

With total sales in A1 and fees in B1, use this formula in C1 and format C1
as Percentage:

=B1/A1

Regards,
Per

"Rob" skrev i meddelelsen
...
I am hoping some genius out there can help me with a formula.
I want to do this€¦. First cell has total sales of 10,000, Second sell
has
fees of 100. I want the 3rd cell to tell me what percentage of the total
sales are going toward fees.
Anyone know? It would be appreciated if you could tell me what formula to
put in the 3rd cell.
Thanks rob

In cell A 1 I have 10,000.

In cell A 2 I have 100.

In cell A 3 I have:-

=(A2/A1)*100

This returns 1.

If my comments have helped please hit Yes.

"Rob" wrote:

I am hoping some genius out there can help me with a formula.
I want to do this€¦. First cell has total sales of 10,000, Second sell has
fees of 100. I want the 3rd cell to tell me what percentage of the total
sales are going toward fees.
Anyone know? It would be appreciated if you could tell me what formula to
put in the 3rd cell.
Thanks rob

If I have 10 kids and 4 of them are girls, then the fraction of my kids that
are girls is 4/10 or 0.25
We multiply this fraction by 100 and say the percentage is 25%. This means
that if I had the same distribution and I had 100 kids (rather than 10)
then 25 of them would be girls. That is percentage in a nut-shell!

If your 10000 is in A1, and 100 in B1 then use =B1/A1 and format the cell
with the % tool to see 1% in the cell
OR
use =B1*100/A1 to see 1 in the cell

best wishes


"Rob" wrote in message
...
I am hoping some genius out there can help me with a formula.
I want to do this€¦. First cell has total sales of 10,000, Second sell
has
fees of 100. I want the 3rd cell to tell me what percentage of the total
sales are going toward fees.
Anyone know? It would be appreciated if you could tell me what formula to
put in the 3rd cell.
Thanks rob

"Rob" wrote:
I am hoping some genius out there can help me with a formula.
[....]
I want the 3rd cell to tell me what percentage of the total
sales are going toward fees.

Doesn't take a genius to answer this, so I can probably help ;-).

If the first cell is A1 and the second cell is B1, the formula in the third
cell might be;

=B1/A1

formatted as Percentage.


----- original message -----

"Rob" wrote:
I am hoping some genius out there can help me with a formula.
I want to do this€¦. First cell has total sales of 10,000, Second sell has
fees of 100. I want the 3rd cell to tell me what percentage of the total
sales are going toward fees.
Anyone know? It would be appreciated if you could tell me what formula to
put in the 3rd cell.
Thanks rob

Hi,
I assume 10000 is in A1 and 100 in A2 so in A3 enter

=A2/A1

Format as percentage

"Rob" wrote:

I am hoping some genius out there can help me with a formula.
I want to do this€¦. First cell has total sales of 10,000, Second sell has
fees of 100. I want the 3rd cell to tell me what percentage of the total
sales are going toward fees.
Anyone know? It would be appreciated if you could tell me what formula to
put in the 3rd cell.
Thanks rob