Forum Discussion
Solved
Calculation returns wrong value
Simple calculation but returns wrong value. =H33*G34 H33 is overtime hours, formatted as number, 2 decimals (.18) G34 is payrate, formatted as Accounting, 2 decimals ($21) The ...
- I suspect H33 is not 0.18, but 0.18333333 (11 minutes). Regardless of how you format the cell, it doesn't change the actual value of the cell contents.
Try: =Round(H33,2)*G34
I suspect H33 is not 0.18, but 0.18333333 (11 minutes). Regardless of how you format the cell, it doesn't change the actual value of the cell contents.
Try: =Round(H33,2)*G34
Try: =Round(H33,2)*G34
Thanks....this worked. I had to copy the "value" of H33 (it was built on evaluating other cells) into the next cell and round that. Very frustrating to understand why, and make me lose trust in Excel calculations....