Web Development

Ask something
Discussion Locked

FIX A TAX FORMULA IN EXCEL SHEET

0 helpful
5 replies

by ffontan1

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Qestion:

I have a col. D , row 1 amount 20.00
I have a col. E , row 1 amount 3 tax formula no. (07.25%), (8.25%), (7.75%)
I have a col. F , row 1 I one the total of all col. but it did not work
can you gift me the formula.

Only one formula at a time.

5 replies

by dklippert

Your question is not very clear.
You can't have 3 variables in one cell without a lot of fooling around. The Total formula could be
=(D1*E1)+(D1*E2)+(D1*E3)
If the rates were entered in seperate rows.

by khall3

your question isn't totally clear but I think your problem is you have 3 variables in column E. You need to brake those percentages into serpate columns. then you simply need a formula such as =d1*e1. This would multiply $20.00(d1) times 7.25%(E1).

This discussion is closed to new replies.