Thread: Modulas
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max
 
Posts: n/a
Default 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?