Modulas

  • Thread starter Thread starter kuansheng
  • Start date Start date
K

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?
 
If you want expressed as an integer
=MOD(A1, B2)

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