MOD Function

[FRED_SHEET]

I was trying to use the MOD function to get the portion of a number to the right of the decimal point.

=MOD(M32,INT(M32))

However when M32 is zero I get an error message #DIV/0

In most cases the number in M32 will be in the format XX.XXXXX.

What function can I use to avoid this error message?

 

[Tetra201]

Try

=MOD(A1,1)

 

[Rick Rothstein]

Try

=MOD(A1,1)

Works as long as the value in A1 is not negative.

Alternately, you can do this (works with all numbers)...

=A1-TRUNC(A1)

 

[FRED_SHEET]

Try

=MOD(A1,1)

I tried that and it did the trick.

Thanks for your help!

 

[Rick Rothstein]

I tried that and it did the trick.

I don't know if you saw Message #3 or it and your last message "crossed in the ether", so just checking... will you ever have any negative values to parse?

 

[FRED_SHEET]

I don't know if you saw Message #3 or it and your last message "crossed in the ether", so just checking... will you ever have any negative values to parse?

NO I should not have any negative values.

Thanks for questioning that.

 

[FRED_SHEET]

Thanks this looks like it might be a better option, although I am not going to have negative numbers.

It is great to learn two ways of accomplishing this.

Thanks