calculate if a vlue is out the 3%

User avatar
sal21
PlatinumLounger
Posts: 4354
Joined: 26 Apr 2010, 17:36

calculate if a vlue is out the 3%

Post by sal21 »

I have this 2 var(are double deimensioned):

var=8171
var1=4137,88

And i have a value limit of 3%

i need to calculate if var is UP respect of the 3% respect var1, if the test is true then....

how to?

User avatar
HansV
Administrator
Posts: 78457
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: calculate if a vlue is out the 3%

Post by HansV »

If Abs(Var/Var1 - 1) > 0.03 Then
Best wishes,
Hans