+ Reply to Thread
Results 1 to 3 of 3

Percentage Formula

  1. #1
    Registered User
    Join Date
    08-12-2011
    Location
    Nashville, TN
    MS-Off Ver
    Excel 2003
    Posts
    5

    Percentage Formula

    How could I use a formula to calculate the following for a retail price.

    I need to subtract 65% THEN, 15%

    For instance,

    If retail= $4.50

    Subtract 65% = $1.58

    Subtract 15% = $1.34


    Thank you very much

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,327

    Re: Help with Percentages Formula

    Hello & Welcome to the board,

    How about...

    (A1*0.35)*0.85

    A1 = $4.50
    HTH
    Regards, Jeff

  3. #3
    Registered User
    Join Date
    08-14-2011
    Location
    Lowestoft, England
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Percentage Formula

    Or if you need to see both figures -
    A1*0.35
    A2*0.85

+ 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