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. Advertising

  2. "J" <> wrote in message
    news:...
    > 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?


    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. Advertising

  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.

    "Lawrence Garvin [MVP]" wrote:

    > "J" <> wrote in message
    > news:...
    > > 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?

    >
    > 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
    >
    >
    J, Jun 22, 2009
    #3
  4. "J" <> wrote in message
    news:...
    > 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.


    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..


    "Lawrence Garvin [MVP]" wrote:

    > "J" <> wrote in message
    > news:...
    > > 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.

    >
    > 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
    >
    >
    J, Jun 23, 2009
    #5
    1. Advertising

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. FrisbeeĀ®
    Replies:
    37
    Views:
    1,065
  2. Brian Young
    Replies:
    2
    Views:
    514
    Juhura Nagamichi
    May 9, 2004
  3. rossco
    Replies:
    2
    Views:
    843
    rossco
    Nov 24, 2005
  4. GT

    350d serial number - what serial number?!?

    GT, Apr 6, 2005, in forum: Digital Photography
    Replies:
    6
    Views:
    574
    eatmorepies
    Apr 7, 2005
  5. Ace
    Replies:
    2
    Views:
    500
    Randy Berbaum
    Sep 17, 2005
Loading...

Share This Page