Creating a Formula in Excel
 

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

Creating a Formula in Excel
 

This is the formula
=B1/A1
--
Click yes if helped
Greatly appreciated
Eva


"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

Creating a Formula in Excel
 

10,000 in A1

100 in A2

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

If my comments have helped please hit Yes.

Thanks.






"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

Creating a Formula in Excel
 

Hi Rob

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

--
Regards
Roger Govier

"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


__________ 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

Creating a Formula in Excel
 

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

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

C1 =B1/A1 returns 1.00%

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


Gord Dibben MS Excel MVP


On Fri, 8 Jan 2010 08:39:01 -0800, 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