Spreadsheet forumulae query - help please

[#1]

 On a spreadsheet I am trying to lay out.... I have column A   ( quantity value)   (150 )       column B (cost per unit value)  0.29p  column C total of  (A times B )

So, that would be =SUM(A*B)     giving me a  total value...  43.5p

How do I expand that formula to increase the final "total value" figure by 5%.... and have the result in Colum C as the total including the 5% - not as a 5% in a new column.

[#2 · Accepted solution]

Column C is  just =A*B*1.05

no SUM needed , or are you also summing all the rows for a total ?

[#3]

I suspect you're going about this the wrong way.

I suspect "SUM" not required to multiply 2 (single) values together.

I suspect you should be referring to 'cell' references not "A" and "B" in your forumula in column C, e.g. A1*B1.

Why not just include *1.05 to the formula in col C to increase the value by 5%, i.e. A1*B1*1.05?

Edit: @MisterW types faster than me.

[#4]

@MisterW  Thank you for the speedy reply...

At the moment, it is only for the single entry as described... which will suffice my needs for now.
I do have some info on forumulae, but could not find the answer to this problem

Thanks

[#5]

(a*b)*1.05

[#6]

Good practice to use brackets, forces a computer to think like a human……..