Velocity Reviews > Number changes

# Number changes

J
Guest
Posts: n/a

 06-22-2009
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.

Lawrence Garvin [MVP]
Guest
Posts: n/a

 06-22-2009
"J" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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/pro...awrence.Garvin

J
Guest
Posts: n/a

 06-22-2009
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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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/pro...awrence.Garvin
>
>

Lawrence Garvin [MVP]
Guest
Posts: n/a

 06-22-2009
"J" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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???

--
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/pro...awrence.Garvin

J
Guest
Posts: n/a

 06-23-2009
Ah, that works. Didn't know the TRUNC function, so your previous explanation
didn't mean too much to my non-Excel brain!
J..

"Lawrence Garvin [MVP]" wrote:

> "J" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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/pro...awrence.Garvin
>
>