ExcelBanter - formula using Divisibility test

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - formula using Divisibility test (https://www.excelbanter.com/excel-programming/355741-formula-using-divisibility-test.html)

kspeedy28

formula using Divisibility test

I am trying to use a divisibility test in a formula to determine if the
answer comes out as a whole number or not.

Nigel

formula using Divisibility test

use the Modulus function that returns zero for the 'whole' number test you
require e.g..........

=IF(MOD(A1,B1)0,"Non Divisible","Divisible")

--
Cheers
Nigel

"kspeedy28" wrote in message
...
I am trying to use a divisibility test in a formula to determine if the
answer comes out as a whole number or not.

All times are GMT +1. The time now is 11:40 PM.