Try: =SUM(A1*A2,A5) or simply: =A1*A2+A5
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"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?
|