+ Reply to Thread
Results 1 to 3 of 3

Enter a Percentage and have it show up as a dollar amount in the same cell

  1. #1
    Registered User
    Join Date
    05-02-2012
    Location
    Geebung, Australia
    MS-Off Ver
    Excel 2011
    Posts
    12

    Enter a Percentage and have it show up as a dollar amount in the same cell

    Hi

    I want to be able to enter a percentage discount in cell F17 of my quote template and have it show in F17 as the equivalent dollar amount, ie; the discount of 2.5% of $1000 is entered into F17 as 2.5% but shows in F17 as $25.00. Is there a function or formula I can use for this?

    Thanks

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,572

    Re: Enter a Percentage and have it show up as a dollar amount in the same cell

    1. No. Choose either a formula or a value. Formulas do not replace themselves with their calculated values.
    2. Very bad idea. You should have a cell/column for the discount %'s and a different column for the base price.
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    05-02-2012
    Location
    Geebung, Australia
    MS-Off Ver
    Excel 2011
    Posts
    12

    Re: Enter a Percentage and have it show up as a dollar amount in the same cell

    Thank you for that. If it's not possible its not possible. Simply wanted to have that option if I could.

+ 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