Excel is Calculating Incorrectly
Increase the number of decimal places on those cells. You might see
that C10 actually contains 9.6, but it displays as 10 because of the
format used.
Hope this helps.
Pete
On Oct 22, 9:30*am, Mike wrote:
I'm using the below formula:
=IF(F10=0,"0",SUM(C10/F10))
The data entry in F10 is 5. The data entry in C10 is 10. *That should equate
to 200%; however excel keeps giving me 192% as the equation. This is
happening in many of the cells using this particular formula type.
Please assist.
Thanks,
Mike
|