View Single Post
  #2   Report Post  
JulieD
 
Posts: n/a
Default

Hi

how about
=A1*A2+A5
where A1 and A2 contain qty and price (in any order) and A5 contains the tax
value
if this still doesn't work, check that your numbers are actually numbers
(use the ISNUMBER(A1) function to see)
--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"hellokitty" wrote in message
...
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?