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

FranFran
I've made my fair share of mistakes, and if I can help you avoid a few, I'd sure like to try.
Chat with Fran
MaxineMaxine
I respect you enough to keep it real.
Chat with Maxine
LaoLao
The path is yours to walk; I am only here to hold up a mirror.
Chat with Lao

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