Help with formula of formula

[dontgetit]

Hello! New here and struggling with a formula of a formula issue I have been having on my invoices I create in Excel. These are item prices multiplied by their markup percentage and then multiplied again by the number that were purchased. Here goes it:

F11 is PRODUCT(20.35*1.15)=23.40
G11 is 2
H11 is PRODUCT(F11*G11)=46.81

Obviously this is incorrect because 23.40*2=46.80


I am having this issue on some of my product lines but not all of them, which leads me to believe the error is occurring due to rounding during the percentage calculation. But how do I fix this so that the final tally is correct?

I have tried putting the F11 in parenthesis so that it shows I want the whole value multiplied, but that did not change anything. I also tried calling technical support, but that turned out to be a waste of 45 minutes of my life that I will never get back.

Any help is much appreciated!

[shg]

Welcome to the board.

Please take a few minutes to read the Forum Rules about thread titles, and then amend yours accordingly.

Thanks.

[dontgetit]

Okay, so got help from a friend. I should have used

=ROUND(20.55*1.15,2)
This still gives the correct 23.40 and also makes it so that H11 calculates correctly