+ Reply to Thread
Results 1 to 5 of 5

How to create a formula to calculate the sales tax?

  1. #1
    Registered User
    Join Date
    09-29-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    10

    How to create a formula to calculate the sales tax?

    In cell G5, enter a formula that calculates the state sales tax by multiplying the base cost of the car (in F5) by 7%. Copy the formula down to cells G6:G16. How would I create a formula for this? attached is the spreed sheet.
    Attached Files Attached Files

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: How to create a formula to calculate the sales tax?

    In G5 use

    =F5*0.07

    Copy cell G5 and paste across G6:G16

    Alternatively, hover on right bottom of Cell G5 till you see a '+' sign. Click and drag down till G16 or simply double click
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Registered User
    Join Date
    09-29-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: How to create a formula to calculate the sales tax?

    Thank you and I need help with one more problem it says to: In cell H5, enter a formula that adds the sales tax (in G5) to the base price of the car (in F5). Copy the formula down to cells H6:H16.

  4. #4
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: How to create a formula to calculate the sales tax?

    In H5 use

    =F5+G5

    Copy cell H5 and paste across H6:h16
    Alternatively, hover on right bottom of Cell H5 till you see a '+' sign. Click and drag down till H16 or simply double click

  5. #5
    Registered User
    Join Date
    09-29-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: How to create a formula to calculate the sales tax?

    That was so simple .. I swear excel elludes me all the time but thank you again so much.. i really appreciate it

+ 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