Source: blog.2createawebsite.com

Question:

I'm trying to create a spreadsheet which automatically updates the price when the percentages OH / benefit change. However I still get a result that is not correct mathmatically. I have expanded even data in individual cells to work with it instead of relying on my limited formula writing experience. But the answer is not mathematically correct. I know that this must be the error of the operator somewhere but I can not understand.

Here is an excerpt; all is good until the last column. An audit simple calulator will confirm that the "expanded with Mark-up price" is not correct (11.25 x 47 is not 528.54) OH, profit and bond are added respectively (unit x OH + ((unit_x_OH) xprofit) +...)Please help. TIA a sample of the problem:

Answer:

SSMess,

I would say that you have cells with $ amounts in formatted as currency to 2 decimal places?

If you increase the number of decimal places (for 4) you'll see that the unit price value OH is actually $0,525, unit is $0.2205 and the value of w/increase of unit price is of $11.2455, and 47 x 11.2455 = $528.54 (for 2 RFP).

Formatting cells as currency to Mon shows rounded values but in the background, Excel continues to make his calculations with as many decimal places as available.

I guess you want to see 47 x 11.25 = $528.75, in which case you can try to change your formulas as follows:

= ROUND(C4*A4,2)

= ROUND (C4-E$ 2.2)

= ROUND ((C4+E4) ** F$ 2.2)

= ROUND ((C4+E4+F4) ** G$ 2.2)

___________

Sincerely, Tom