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

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

Excel is Calculating Incorrectly
 

I can only think that the value of C10 or D10 is displayed as a rounded
figure - ie C10 might actually contain 9.6 but your cell is formatted to show
this as 10.

Sam


"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

Excel is Calculating Incorrectly
 

cell C10 contains 9.6 or F10 contains 5.2

On Oct 22, 1:30*pm, 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

Excel is Calculating Incorrectly
 

.... further to which (for the benefit of the OP, not muddan), why use SUM()
when you haven't told Excel what to add to C10/F10? If you want C10/F10,
say C10/F10, not SUM(C10/F10).
If you don't know what the SUM function does, please look it up in Excel
help, rather than just randomly scattering it around your formula.
At the very least, if you want to use unnecessary functions, why not give us
some variety, and change SUM(C10/F10) to AVERAGE(C10/F10) or MIN(C10/F10) or
MAX(C10/F10) or PRODUCT(C10/F10) or ...
None of them will give a different answer from C10/F10, but we do get rather
bored with seeing SUM used unnecessarily when there are plenty of other
functions that could be used unnecessarily in the same pointless way.
<end of rant

Also, are you sure that you want the zero to be a text string wehen
otherwise you are calculating a number?

I think it likely that instead of
=IF(F10=0,"0",SUM(C10/F10))
what was probably wanted was
=IF(F10=0,0,C10/F10)
--
David Biddulph

"muddan madhu" wrote in message
...
cell C10 contains 9.6 or F10 contains 5.2

On Oct 22, 1:30 pm, 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