|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 8th, 2010, 04:39 PM
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
January 8th, 2010, 04:44 PM
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
January 8th, 2010, 04:44 PM
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
January 8th, 2010, 04:52 PM
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 news  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
January 8th, 2010, 04:58 PM
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
