Hardcoded\calculated #'s - Are the same but when multiplied, product value is different.

I joined Excel Forum specifically to get help with the following problem. I consider myself and intermediate Excel user and just can’t figure this one out. See attachment for reference

I have two values; for discussion purposes consider the first value $45.70 an unloaded financial figure and the second value $95.53 the loaded value.

Essentially, the 95.53 is derived from adding fringe, overhead and G&A costs to the $45.70 value.

The issue: In multiplying the $95.53 * 36 the product is $3,439.08, but if I multiply the unloaded value $45.70 * 36 = $1,645.20 and apply the fringe, overhead and G&A math the product is $3,439.11; three cents difference. I’ve tried all variations of rounding, truncating etc. to no avail.

I know that the loaded value $95.53 is correct, as I can apply the formulas against the unloaded value $45.70 and my product is $49.83. $45.70 + $49.83 = $95.53.

Attached is a snapshot of my spreadsheet with the accompanying formulas.

BTW…. By rounding down I can get to within 1 penny difference but no lower. HELP!
excel.jpg

Hi
My initial thoughts are that it appears to be the internal values that are causing you the problem. When you use the fringe, overhead and G&A, those figures are displayed to 4 decimal points. Have you tried entering those values up to 2 decimal points and see if that cures your issue.
Hope this helps.
Tony

@ Pepe.... thanks, read the article and tried most everything in it. have turned precision on\off etc.

@ARGK.... the figures are percentages. in example the 0.3821 is 38.21%, I did format the value to % with 2 decimal points .... no difference