| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| creating formula in excel | Excel Worksheet Functions | |||
| Need Help in Creating Excel Formula | Excel Discussion (Misc queries) | |||
| Need help on creating a formula in excel | Excel Worksheet Functions | |||
| Creating an Excel Formula | Excel Discussion (Misc queries) | |||
| Creating a formula in excel | Excel Worksheet Functions | |||
Hybrid Mode
