Number changes

Discussion in 'Microsoft Certification' started by J, Jun 22, 2009.

  1. J

    J Guest

    Hi,
    I am trying to build a formula that would return an "Alert" if a number
    changes to another whole number, e.g. 5.9% to 6.1%.
    Can anyone help?
    Regards,
    J.
     
    J, Jun 22, 2009
    #1
    1. Advertisements

  2. Not sure what you're trying to build the formula with, and this is not a
    "general help" forum -- this is help for users wanting to get Microsoft
    Certifications..

    but it should be as simple as using a truncate() function.

    For example... if truncate(OldValue) = truncate(NewValue), then the values
    have not changed.



    --
    Lawrence Garvin, M.S., MCITP:EA, MCDBA
    Principal/CTO, Onsite Technology Solutions, Houston, Texas
    Microsoft MVP - Software Distribution (2005-2009)

    MS WSUS Website: http://www.microsoft.com/wsus
    My Websites: http://www.onsitechsolutions.com;
    http://wsusinfo.onsitechsolutions.com
    My MVP Profile: http://mvp.support.microsoft.com/profile/Lawrence.Garvin
     
    Lawrence Garvin [MVP], Jun 22, 2009
    #2
    1. Advertisements

  3. J

    J Guest

    Hi Lawrence,

    Thanks for your reply. Didn't realise this was a Microsoft Cert discussion
    group, I logged on in the General Discussions. Ooops, sorry about that.

    I am, however, trying to get an "Alert" for when the number does change. The
    formula =if(a1=b1,"","ALERT") doesn't really do that as some numbers change
    within the decimal point, i.e. 5.1 to 5.2 shouldn't generate an Alert whereas
    5.1 to 4.9 should do, and that's the formula I'm trying to build.

    Regards,

    J.
     
    J, Jun 22, 2009
    #3
  4. And.. so.... did you miss my entire discussion about Integer Truncation
    functions???

    =IF(TRUNC(A1) = TRUNC(B1), "", "ALERT")


    --
    Lawrence Garvin, M.S., MCITP:EA, MCDBA
    Principal/CTO, Onsite Technology Solutions, Houston, Texas
    Microsoft MVP - Software Distribution (2005-2009)

    MS WSUS Website: http://www.microsoft.com/wsus
    My Websites: http://www.onsitechsolutions.com;
    http://wsusinfo.onsitechsolutions.com
    My MVP Profile: http://mvp.support.microsoft.com/profile/Lawrence.Garvin
     
    Lawrence Garvin [MVP], Jun 22, 2009
    #4
  5. J

    J Guest

    Ah, that works. Didn't know the TRUNC function, so your previous explanation
    didn't mean too much to my non-Excel brain!
    Cheers for your help,
    J..
     
    J, Jun 23, 2009
    #5
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.