Anthony- You can use the ROUNDDOWN function. In the example you gave, the formula would be =ROUNDDOWN(+A1/A2,0). In English it says to round A1/A2 down to the nearest integer. Parker -----Original Message----- From: Colli, Anthony G [mailto:Anthony.Colli@xxxxxxx] Sent: Monday, August 05, 2002 1:24 PM To: MSO FreeLists (E-mail) Subject: [mso] EXCEL integer division Folks- Does Excel support integer division? Where regular division returns 11/4 = 2.75 Integer division returns 11\4 = 2 If I try =A1\A2 in Excel I get #NAME? Is there something else I can use? -Anthony Anthony Colli Laboratory for Clinical Biochemistry Research UVM Pathology 208 South Park Drive, Suite 2 Colchester, VT 05446 ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx?Subject=unsubscribe Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles ************************************************************* ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx?Subject=unsubscribe Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles *************************************************************