| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate mean of test scores from rows of test answers | Excel Discussion (Misc queries) | |||
| If formula to test several conditions | Excel Worksheet Functions | |||
| test for a formula | Excel Discussion (Misc queries) | |||
| how to use the divisibility condition in excel with 'if' statemen. | Excel Programming | |||
| test for formula result | Excel Programming | |||
Hybrid Mode
