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

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post FrisbeeŽ MCSE 37 09-26-2005 04:06 PM hari VHDL 6 05-02-2004 04:10 PM taras ASP .Net 1 04-17-2004 04:51 AM makok VHDL 1 02-23-2004 06:04 PM Andre Ranieri ASP .Net Datagrid Control 1 12-03-2003 03:51 AM