Multiples of values in excel

gemsey · #1 Jan 30, 2008, 02:44 AM

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.

Capuchin · Jan 30, 2008, 02:49 AM

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.



At Ask Me Help Desk you can ask questions in any topic and have them answered for free by our experts. To ask questions or participate in answering them you must register for a free account. By registering you will be able to: Get free answers from experts in any of our 300+ topics. Accept money for answers that you provide. Communicate privately with other members (PM). See fewer ads. Sign Up!