topic Re: Spreadsheet forumulae query - help please in Tech Help - Software/Hardware etc

Spreadsheet forumulae query - help please

shutter — Wed, 31 Jul 2024 14:29:44 GMT

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.

Re: Spreadsheet forumulae query - help please

MisterW — Wed, 31 Jul 2024 14:42:33 GMT

Column C is just =A*B*1.05

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

Re: Spreadsheet forumulae query - help please

RobPN — Wed, 31 Jul 2024 14:48:12 GMT

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.

Re: Spreadsheet forumulae query - help please

shutter — Wed, 31 Jul 2024 14:55:01 GMT

@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

Re: Spreadsheet forumulae query - help please

zpeterk — Thu, 01 Aug 2024 05:38:54 GMT

(a*b)*1.05

Re: Spreadsheet forumulae query - help please

Champnet — Thu, 01 Aug 2024 06:31:06 GMT

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