answersLogoWhite

0

=SUM(A1:A12)*.065 [assumes A1:A12 contains the purchased items and the tax rate is 6.5%]

User Avatar

Wiki User

15y ago

Still curious? Ask our experts.

Chat with our AI personalities

BeauBeau
You're doing better than you think!
Chat with Beau
CoachCoach
Success isn't just about winning—it's about vision, patience, and playing the long game.
Chat with Coach
ViviVivi
Your ride-or-die bestie who's seen you through every high and low.
Chat with Vivi

Add your answer:

Earn +20 pts
Q: What formula in Microsoft excel would compute a total cost with tax?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Continue Learning about Math & Arithmetic

In Microsoft Excel how do you use a formula to calculate the percentage of use of a set of symbols?

In A1, put the total number of symbols.In B1, put the number of symbols used.In C1, enter the formula =A1/B1Format C1 for percent and observe the answer.


How do you Compute for the linear meter of the fence?

To compute the linear meter of a fence, measure the total length of the area you want to enclose. This involves adding together the lengths of all the sides of the fence. If the area is rectangular, use the formula: linear meters = 2 × (length + width). For irregular shapes, sum the lengths of each side individually to get the total linear meters required.


How do you work out the percentage out of a group of numbers in excel?

Assuming you want the percentage of the total, and that the numbers are organized in a column: you first calculate the total at the bottom of a column of numbers. Then, in the next column, you put a formula that divides the number by the total. (It helps to press F4 for the total - that way, its cell reference won't change when you copy the formula down.) Then you select the range and give it a percentage format. This will automatically multiply it by 100 for display purposes; for this reason, I didn't include the "*100" in the formula.


How do cashiers use math?

Cashiers have to make checks, count money, pay bills by cash, calculate the total of the payments, weigh items, and compute and record the total transactions.


What is the synonym for count?

add up, total, reckon, calculate, compute, tally, number consider, judge, regard, deem, rate