Modulas

[kuansheng]

Hi Guys,

Is there any formula that can determine the modula value of a division
perform between two cell. Let say A1 contain 10 and is divided by B2
which contain 3. I would get 3.33333333, what i need is the modula of
the division which is only 3 less the decimal. Anyone can help?

 

[Max]

One way, try: =TRUNC(A1/B2)

 

[Guest]

If you want expressed as an integer
=MOD(A1, B2)

If you want expressed as a decimal
=MOD(A1, B2)/B2

 

[kuansheng]

Thanks Max that is what i am looking for.

 

[Max]

You're welcome !