Originally Posted by DataMiser Well in your Iff statement you are comparing x to temp and adding 1 if they are not the same The problem with that is that on the line before you set temp=x*factor so unless factor is 1 they will not be the same and it will add 1 Try this instead Code: AsymUp = (Temp + IIf((X*Factor) = Temp, 0, 1)) / Factor Seems to work fine now! I am doing some testing but.
AsymUp = (Temp + IIf((X*Factor) = Temp, 0, 1)) / Factor
---------------------------- R Cordina -----------------------------
View Tag Cloud
Forum Rules
Originally Posted by DataMiser
Reply With Quote
