View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
trip_to_tokyo[_3_] trip_to_tokyo[_3_] is offline
external usenet poster
 
Posts: 833
Default 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