Is it possible to have a calculation that returns "yes" if the number in "field1" is equally divisible by the number in "field2"?

For example, 4 divided by 2 would return "Yes"

8 divided by 5 would return "No"

LR

Have a try with

Choose(Mod(YourNumber1,YourNumber2),"Yes","No")

Unless equally means something else

Version: v6.x

Platform: Mac OS 9

Good call with the Choose function!

Oops--Don't think that Choose function works for "No". Since the Mod() function returns the remainder of the division, I think the only way to check it properly is:

If(Mod(YourNumber1;YourNumber2);"No";"Yes")

Absolutely !

Unless we change it to :

Choose(not MOD(field1,field2),"No","Yes")

The only difference between the 2 methods is that if both fields are empty, Choose would return No, while If would stay Blank

Version: v6.x

Platform: Mac OS 9

Hi Ender,

Ugo's calculation worked for me, but the calculation field needed to have a result of "Number", a result of "Text" did fail.

Lee

Version: v6.x

Platform: Mac OS 9

Great solutions. Just what the doctor ordered. THANKS.

LR