Hi all,

I'm trying to find a way of getting multiples of a value so I can use it in an IF statement. Basically I need the multiples of 60, I want to be able to say IF value is a multiple of 60 then this will happen.

Is there a way to do this, I've been looking at LCMs, GCDs without any luck.

Check MOD(n,60)

This returns the remainder of n/60. If MOD(n,60) = 0 then n is divisible by 60 and so is a multiple of 60.