The formula uses the fact that for a perfectly divisible number, the numerator must be zero.
Count numbers between 74 and 174 that are divisible by 5.
Find numbers between 100 and 200 that are exactly divisible by 2, 3 and 5.
How to find exact multiples of 3 between 5 and 200.
Category: Math and trigonometry
Returns the sum of the products of corresponding array components
SUMPRODUCT(array1, [array2], [array3], ...)
Returns the remainder from division
Category: Lookup and reference
Returns the row number of a reference
Returns a reference indicated by a text value
Create a new account
I already have an account
You haven't saved the current formula!
Are you sure to continue?
You haven't save the current formula!
Made with in Istanbul
START LEARNING EXCEL with SHEETZOOM