My rounding error in a simple IF
 

col:A col:B col:C col:D col:E
4.82 -.02 =4.80 vs 4.80 =0%
why am i getting an error here?
=if(A0.10,(D-C)*100/C,0)

Im expecting a 0% difference between C AND D
IT SHOULD READ 0%
DOH! WHAT am i doing wrong here?
I GET A number anywhere from 0.03% to .09%
any tips to do this right?

My rounding error in a simple IF
 

Not quite following you on this...

Does "=4.80" mean that's a calculated value?

If so, the 4.80 may not be the true value of that cell. It may be something
like 4.80000000056889

You should probably round it off to 2 decimal places.

--
Biff
Microsoft Excel MVP


"garron" wrote in message
...
col:A col:B col:C col:D col:E
4.82 -.02 =4.80 vs 4.80 =0%
why am i getting an error here?
=if(A0.10,(D-C)*100/C,0)

Im expecting a 0% difference between C AND D
IT SHOULD READ 0%
DOH! WHAT am i doing wrong here?
I GET A number anywhere from 0.03% to .09%
any tips to do this right?

My rounding error in a simple IF
 

You should probably round it off to 2 decimal places.

Round it using the ROUND function. Don't just *format* it to show only 2
decimal places. Formatting is only for *display* purposes.

--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
Not quite following you on this...

Does "=4.80" mean that's a calculated value?

If so, the 4.80 may not be the true value of that cell. It may be
something like 4.80000000056889

You should probably round it off to 2 decimal places.

--
Biff
Microsoft Excel MVP


"garron" wrote in message
...
col:A col:B col:C col:D col:E
4.82 -.02 =4.80 vs 4.80 =0%
why am i getting an error here?
=if(A0.10,(D-C)*100/C,0)

Im expecting a 0% difference between C AND D
IT SHOULD READ 0%
DOH! WHAT am i doing wrong here?
I GET A number anywhere from 0.03% to .09%
any tips to do this right?