"Yes" if "field1" is equally divisible by "field2"

[ibiubu]

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

[Ugo DI LUCA]

Have a try with

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

Unless equally means something else

Version: v6.x

Platform: Mac OS 9

[Ender]

Good call with the Choose function!

[Ender]

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")

[Ugo DI LUCA]

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

[Lee Smith]

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

[ibiubu]

Great solutions. Just what the doctor ordered. THANKS.

LR