"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?
|