software

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?One way, try: =TRUNC(A1/B2)
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;kuanshengquot; gt; wrote in message oups.com...
gt; Hi Guys,
gt;
gt; Is there any formula that can determine the modula value of a division
gt; perform between two cell. Let say A1 contain 10 and is divided by B2
gt; which contain 3. I would get 3.33333333, what i need is the modula of
gt; the division which is only 3 less the decimal. Anyone can help?
gt;
If you want expressed as an integer
=MOD(A1, B2)

If you want expressed as a decimal
=MOD(A1, B2)/B2quot;kuanshengquot; wrote:

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

Thanks Max that is what i am looking for.You're welcome !
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;kuanshengquot; gt; wrote in message oups.com...
gt; Thanks Max that is what i am looking for.
gt;