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.
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.
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 *
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.
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
That was so simple .. I swear excel elludes me all the time but thank you again so much.. i really appreciate it
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks