Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Math & Sciences (https://www.askmehelpdesk.com/forumdisplay.php?f=402)
-   -   Creating a fornula in excel to find a percent of something (https://www.askmehelpdesk.com/showthread.php?t=352666)

  • May 11, 2009, 07:55 PM
    mscathieann
    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.
  • May 12, 2009, 10:14 AM
    Unknown008

    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.
  • May 12, 2009, 10:59 AM
    KISS

    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.

  • All times are GMT -7. The time now is 04:49 AM.