10-29-2011, 08:45 AM
Hi,
I am trying to do the calculation on excel than VB script. I am receiving errors when executing the script on formula column. Can some one tell me if this is right or wrong.
Here's the calculation:
Variance will be(on column C) =A2-B2
D will be =IF(Abs(C2) < 1,"PASS","FAIL")
When I execute the formula in the default sheet it works fine but when I open the test in QTP the data sheet is displaying Formula error in D column. Am I doing something wrong here or I can not do these functions on data sheet. Can some one guide?
Thanks!
I am trying to do the calculation on excel than VB script. I am receiving errors when executing the script on formula column. Can some one tell me if this is right or wrong.
Here's the calculation:
Variance will be(on column C) =A2-B2
D will be =IF(Abs(C2) < 1,"PASS","FAIL")
When I execute the formula in the default sheet it works fine but when I open the test in QTP the data sheet is displaying Formula error in D column. Am I doing something wrong here or I can not do these functions on data sheet. Can some one guide?
Thanks!