Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel is Calculating Incorrectly
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel document incorrectly applying read-only | Excel Discussion (Misc queries) | |||
Why does excel sometimes subtract numbers incorrectly? | Excel Worksheet Functions | |||
excel starts incorrectly | Excel Discussion (Misc queries) | |||
Excel incorrectly calculated a formula. Why? How? | Excel Discussion (Misc queries) | |||
When Excel incorrectly Calculates | Excel Discussion (Misc queries) |