ExcelBanter

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - div (https://www.excelbanter.com/excel-worksheet-functions/104708-div.html)

Daniel

div

I remember in algebra or one of the classes I took long ago that I can see
how many times a number could go into another number by using the div,
opposite of mod. What function will let me do that in excel? I don't see a
div function.

Daniel

Ken Johnson

div

Daniel wrote:
I remember in algebra or one of the classes I took long ago that I can see
how many times a number could go into another number by using the div,
opposite of mod. What function will let me do that in excel? I don't see a
div function.

Daniel

Hi Daniel,

How about INT eg INT(7/2)=3

Ken Johnson

All times are GMT +1. The time now is 11:46 AM.