Creating a Formula in Excel

  • Thread starter Thread starter Rob
  • Start date Start date
R

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
 
10,000 in A1

100 in A2

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

If my comments have helped please hit Yes.

Thanks.
 
Hi Rob

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

--
Regards
Roger Govier

Rob said:
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
Click to expand...

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

The message was checked by ESET Smart Security.

http://www.eset.com
 
A1...........10000

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

C1 =B1/A1 returns 1.00%

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


Gord Dibben MS Excel MVP
 
Back
Top