View Single Post
  #4   Report Post  
Gord Dibben
 
Posts: n/a
Default

"It's not working" means what?

Wrong answer? No answer?

It should work ,but you don't need the SUM Function

=(A1*A2)+A5

Assuming A1 has a numeric quantity, A2 has a numeric price and A5 has a
numeric tax.

=(12*45.99)+25.00

Or do you have a tax rate in A5? Like 10%

=(A1*A2)*1.10


Gord Dibben Excel MVP



On Mon, 11 Apr 2005 16:09:03 -0700, "hellokitty"
wrote:

This should be easy, I want to multiply the quantity of a product by the
price then add the tax to get the total.

I am using/attempting this: =SUM(A1*A2+A5)

But it's not working so apparently I am doing something wrong.

Help?