Results 1 to 5 of 5

Add a percent to a dollar amount HELP!

This is a discussion on Add a percent to a dollar amount HELP! within the Excel Questions forums, part of the Question Forums category; I've been sitting here forever trying to figure out how write the formula to add a percent to a dollar ...

  1. #1
    New Member
    Join Date
    Aug 2009
    Posts
    2

    Default Add a percent to a dollar amount HELP!

    I've been sitting here forever trying to figure out how write the formula to add a percent to a dollar amount.
    $26.24 is in L46 and I need to add 19% to that. I've tried =L46+19% but it reads it as $0.19 and returns a value of $26.43 instead of $31.23. Can anyone help?????

  2. #2
    Board Regular Domski's Avatar
    Join Date
    Jan 2005
    Location
    Leeds, UK
    Posts
    7,178

    Default Re: Add a percent to a dollar amount HELP!

    =L46*1.19

    Dom
    "May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."

    - Guidelines For Posting

    - Mr Excel Articles and PodCasts

    - Display sheet using HTML Maker or Excel Jeanie

    - Something that makes me laugh

    - Please try to remember to use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Board Regular
    Join Date
    Mar 2004
    Posts
    118

    Default Re: Add a percent to a dollar amount HELP!

    Try =L46+(19%*L46)

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Phoenix, Arizona
    Posts
    1,711

    Default Re: Add a percent to a dollar amount HELP!

    Quote Originally Posted by jessgermain View Post
    i've been sitting here forever trying to figure out how write the formula to add a percent to a dollar amount.
    $26.24 is in l46 and i need to add 19% to that. I've tried =l46+19% but it reads it as $0.19 and returns a value of $26.43 instead of $31.23. Can anyone help?????
    =l46*1.19

  5. #5
    New Member
    Join Date
    Aug 2009
    Posts
    2

    Talking Re: Add a percent to a dollar amount HELP!

    Thank you!!!!!

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com