|
| 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, 06:39 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need a formula
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, 06:44 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need a formula
With total sales in A1 and fees in B1, use this formula in C1 and format C1
as Percentage: =B1/A1 Regards, Per "Rob" skrev i meddelelsen ... 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, 06:46 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need a formula
In cell A 1 I have 10,000.
In cell A 2 I have 100. In cell A 3 I have:- =(A2/A1)*100 This returns 1. If my comments have helped please hit Yes. "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, 06:48 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need a formula
"Rob" wrote:
I am hoping some genius out there can help me with a formula. [....] I want the 3rd cell to tell me what percentage of the total sales are going toward fees. Doesn't take a genius to answer this, so I can probably help ;-). If the first cell is A1 and the second cell is B1, the formula in the third cell might be; =B1/A1 formatted as Percentage. ----- original message ----- "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
|
|
#5
January 8th, 2010, 06:48 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need a formula
If I have 10 kids and 4 of them are girls, then the fraction of my kids that
are girls is 4/10 or 0.25 We multiply this fraction by 100 and say the percentage is 25%. This means that if I had the same distribution and I had 100 kids (rather than 10) then 25 of them would be girls. That is percentage in a nut-shell! If your 10000 is in A1, and 100 in B1 then use =B1/A1 and format the cell with the % tool to see 1% in the cell OR use =B1*100/A1 to see 1 in the cell best wishes "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
|
|
#6
January 8th, 2010, 07:04 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need a formula
Hi,
I assume 10000 is in A1 and 100 in A2 so in A3 enter =A2/A1 Format as percentage "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
