Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Modulas
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Modulas
One way, try: =TRUNC(A1/B2)
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "kuansheng" wrote in message oups.com... 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Modulas
If you want expressed as an integer
=MOD(A1, B2) If you want expressed as a decimal =MOD(A1, B2)/B2 "kuansheng" wrote: 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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Modulas
Thanks Max that is what i am looking for.
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Modulas
You're welcome !
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "kuansheng" wrote in message oups.com... Thanks Max that is what i am looking for. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|