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!