+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: UFT / QTP Beginners (https://www.learnqtp.com/forums/Forum-UFT-QTP-Beginners)
+--- Thread: Excel Formula Calculation on datasheet (/Thread-Excel-Formula-Calculation-on-datasheet)
Excel Formula Calculation on datasheet - VJXXXX - 10-29-2011
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!
RE: Excel Formula Calculation on datasheet - Ankesh - 10-31-2011
Hi,
please chk the link http://www.sqaforums.com/showflat.php?Cat=0&Number=477967&Main=477463
This has simalar issue as like yours for excel formula calculation.
Plz let me know if this does not help.
Regards,
Ankesh