HOW TO WORK OUT PERCENTAGE FROM COST PRICE AND PROFIT IN EXCEL

Discussion in 'Microsoft Excel Programming' started by Guest, Oct 30, 2004.

  1. Guest

    Guest Guest

    HOW TO WORK OUT PERCENTAGE FROM COST PRICE AND PROFIT IN EXCEL2000 eg:
    cost price 6.5, selling price 30.00, percentage = ????? Can somebody please
    help?

    Malc
     
    Guest, Oct 30, 2004
    #1
    1. Advertisements

  2. type A1 cost price. inB1 type sale price. In C1 type
    =(B1-A1)/A1
    format C1 as percentage(mine is Excel 2000)


    Malc <> wrote in message
    news:...
    > HOW TO WORK OUT PERCENTAGE FROM COST PRICE AND PROFIT IN EXCEL2000 eg:
    > cost price 6.5, selling price 30.00, percentage = ????? Can somebody

    please
    > help?
    >
    > Malc
     
    R.VENKATARAMAN, Oct 30, 2004
    #2
    1. Advertisements

  3. Guest

    Ken Wright Guest

    Depends what % you want to work out:-

    Fee % expressed as % of Total Cost = (Sell Price - Cost price) / Cost price
    Profit % expressed as Return on Sale (ROS) = (Sell Price - Cost price) / Sell
    price

    In say cell A1 put Cost price
    In say cell A2 put Sell price

    In cell A3 put either:-

    =(A2-A1)/A1 or =(A2-A1)/A2

    depending on which you want

    That's one hell of a markup though, assuming you really meant Cost = 6.5 and not
    Profit = 6.5

    --
    Regards
    Ken....................... Microsoft MVP - Excel
    Sys Spec - Win XP Pro / XL 97/00/02/03

    ----------------------------------------------------------------------------
    It's easier to beg forgiveness than ask permission :)
    ----------------------------------------------------------------------------



    "Malc" <> wrote in message
    news:...
    > HOW TO WORK OUT PERCENTAGE FROM COST PRICE AND PROFIT IN EXCEL2000 eg:
    > cost price 6.5, selling price 30.00, percentage = ????? Can somebody please
    > help?
    >
    > Malc



    ---
    Outgoing mail is certified Virus Free.
    Checked by AVG anti-virus system (http://www.grisoft.com).
    Version: 6.0.784 / Virus Database: 530 - Release Date: 27/10/2004
     
    Ken Wright, Oct 30, 2004
    #3
  4. Celtic_Avenger, Oct 30, 2004
    #4
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Guest

    Sum cost column based on date column and vlookup cost

    Guest, Nov 10, 2003, in forum: Microsoft Excel Programming
    Replies:
    2
    Views:
    575
    Don Guillett
    Nov 10, 2003
  2. lanna

    Auto Calculating Net Profit and YTD Profit - How?

    lanna, Mar 25, 2004, in forum: Microsoft Excel Programming
    Replies:
    4
    Views:
    603
    lanna
    Mar 27, 2004
  3. Guest

    template 4 proj cost analysis (sales value - expenses=profit)

    Guest, Jun 8, 2005, in forum: Microsoft Excel Programming
    Replies:
    0
    Views:
    545
    Guest
    Jun 8, 2005
  4. Replies:
    0
    Views:
    217
  5. Spawnof

    Calculating Sales price by Entering Gross Profit

    Spawnof, Mar 1, 2007, in forum: Microsoft Excel Programming
    Replies:
    9
    Views:
    1,759
    Vinod Jain
    Mar 9, 2007
Loading...

Share This Page