+ Reply to Thread
Results 1 to 3 of 3

formula for cost as percentage of sale price

  1. #1
    elisabeth
    Guest

    formula for cost as percentage of sale price

    I'm trying to figure out how to calculate what percentage of the retail sale
    price the internal cost price is? So, the internal cost is in column G, the
    retail price is in column H and the percentage in Column I

    I'm so confused!!!

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    Microsoft 365
    Posts
    14,762
    It should be simply

    =G1/H1

    format as percentage

  3. #3
    JE McGimpsey
    Guest

    Re: formula for cost as percentage of sale price

    One way:

    =G1/H1

    Format as Percentage.


    In article <A6ACBF8F-2F29-4B7D-B25F-26456799B1FC@microsoft.com>,
    elisabeth <elisabeth@discussions.microsoft.com> wrote:

    > I'm trying to figure out how to calculate what percentage of the retail sale
    > price the internal cost price is? So, the internal cost is in column G, the
    > retail price is in column H and the percentage in Column I
    >
    > I'm so confused!!!


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1