Ask Experts Questions for FREE Help !
Ask
    gemsey's Avatar
    gemsey Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Jan 30, 2008, 04:44 AM
    Multiples of values in excel
    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's Avatar
    Capuchin Posts: 5,255, Reputation: 656
    Uber Member
    		  
    #2

    Jan 30, 2008, 04: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.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Present Values [ 16 Answers ]

Compute the present value of a $100 cash flow for the following combinations of discount rates and times: 1. r = 8 percent. T = 10 years. 2. r = 8 percent. T = 20 years. 3. r = 4 percent. T = 10 years. 4. r = 4 percent. T = 20 years.

Values of a few different coins [ 3 Answers ]

I have a few coins and was just wondering if they had any value besides face value 1916-D Wheatback Penny (2)- 1944 Wheatback Pennies 1776-1976 Eisenhower Silver Dollar Coin 1966 Kennedy Half Dollar 1981 Silver Coin with the words "Diez Pesos" on the front - my Dad found it walking across...

Clomid and increased chance of multiples [ 9 Answers ]

Hey, I haven't researched this yet... and I will, just thought I would post here to see if anyone had any info or thoughts. I am on Clomid trying to get pregnant. My last dose of 50mg did not make me ovulate... shown in blood results. So my doc increased my dose this month to 100mg. **This...

Filter from 2 Columns (Unique values) in Excel [ 1 Answers ]

I need to filter from both these sets of data in excel Set 1 Set 2 ----------------------- 986 Buchanan Dodsworth 563 67 789 Buchanan 235 689 Dodsworth 789 143

View more questions Search