Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Forums » Excel Forums » Functions and Formulas » Formula to check for round value answer

Formula to check for round value answer

Previous | Next
Latest post Mon, Feb 8 2010 12:40 PM by Omar. 1 replies.

  • Mon, Feb 8 2010 7:09 AM

    Formula to check for round value answer

    Reply |Contact

    Not sure how else to phrase that....

     

    What I am looking to do is have a formula that for every multiple of x the formula will perform a lookup.  the look up is not a problem, but I cant find a way to get the multiple of working.

     

    x will be a variable input.  so it must be able to flex to change with the input of the multiple.

     

    I have 25000 lines numbered 1 - 25000 and for every multiple of 10 and 1000 it needs to pull two different results.

     

    Any clues.... will post example if needed.

     

    Thanks

    Raymond
    • Post Points: 21

  • Mon, Feb 8 2010 12:40 PM In reply to

    • Omar
    • Top 10 Contributor
    • Joined on Sat, Jan 12 2008
    • Kitchener, ON
    • Posts 101
    • Points 1,512

    Re: Formula to check for round value answer

    Reply |Contact |Mark as Answer

    Does this get you started?

    =IF(A1=CEILING(A1,1000),"1000true",IF(A1=CEILING(A1,10),"10true","somethingelse"))

     

    Omar Freeman Kitchener, ON
    • Post Points: 5
Page 1 of 1 (2 items) | RSS
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.