Ask Experts Questions for FREE Help !
Ask
    mscathieann's Avatar
    mscathieann Posts: 1, Reputation: 1
    New Member
     
    #1

    May 11, 2009, 07:55 PM
    creating a fornula in excel to find a percent of something
    Billable makes up two cells H&I and $=4% labor is J I make $250.00 billable and I need to fine the percentage for my Commission in J I need a formula that will allow me to get 4% if billable and put the answer in Comm (j)


    Billable 4% 10%
    Materials Comm. Labor Comm.
    Unknown008's Avatar
    Unknown008 Posts: 8,076, Reputation: 723
    Uber Member
     
    #2

    May 12, 2009, 10:14 AM

    Well I don't really understand what you mean...

    Try using (4/100)*cell ID

    By billable... you mean that the sum should be above $250 for the percentage to be calculated? Try searching in the help section, search for conditions. I don't have Windows, but I have Linux. I'm not sure if the commands are the same.
    KISS's Avatar
    KISS Posts: 12,510, Reputation: 839
    Uber Member
     
    #3

    May 12, 2009, 10:59 AM

    You would be better off making the for a constant from say $a$2 where a1 = "Materials commission" and $a$2 = 4. Format $a$2 in percent

    and you can just multiply. The /100 will be done for you.

    =H3*$A$2
    =H4*$A$2; from a fill down operation

    if H3 is the billable amount and $a$2 is the commission in %, like 4. and the is the formula for the commissions.

    Not a good explanation, but neither was your question.

    I think you need to use a constant for the commissions, hence the use of the $ variables. This makes that cell content not move in a relative fashion.

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search


Check out some similar questions!

Excel - Creating a link from on cell/tab to another IN THE SAME FILE [ 4 Answers ]

I am trying to find a way to make a hyperlink in a cell that links to either another cell on the same tab or a cell on another tab WITHIN the same Excel file. Any ideas? EDIT: I want a word in one cell that is a hyperlink so that when a user clicks on it, it will JUMP to another cell or...

Percy Motors has a target capital structure of 40 percent debt and 60 percent common [ 2 Answers ]

Percy Motors has a target capital structure of 40 percent debt and 60 percent common equity, with no preferred stock. The yield to maturity on the company's outstanding bonds is 9 percent, and its tax rate is 40 percent. Percy's CFO estimates that the company's WACC is 9.96 percent. What is Percy's...

Creating a Chart in Excel by including values in X and why Axis [ 2 Answers ]

1) I want to create a chart using the data in my excel sheet. 2) Data in Row 1 should become the x-axis labels in a chart and data in Row 2 should be the y-axis labels and the only data range actually in the chart. 3) When I highlight data in Rows 1 and 2 then click on Chart Wizard both data ...

How to use Proportions to Find the Percent of a Number [ 3 Answers ]

I am in the sixth grade and I want to know how do you use the ides of proportions to find the percent of a number. This is Dynoson.


View more questions Search