Creating a Formula in Excel

[Rob]

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

 

[trip_to_tokyo]

10,000 in A1

100 in A2

=(A1/A2)/100 in A3 and returns 1.#

If my comments have helped please hit Yes.

Thanks.

 

[Eva]

This is the formula
=B1/A1

 

[Roger Govier]

Hi Rob

With 10,000 in A1, and 100 in B1 enter in C1
=B1/A1*100

--
Regards
Roger Govier

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


__________ Information from ESET Smart Security, version of virus
signature database 4754 (20100108) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4754 (20100108) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[Gord Dibben]

A1...........10000

B1...........100

C1 =B1/A1 returns 1.00%

Simple basic arithmetic...........no genius needed.


Gord Dibben MS Excel MVP