Excel Formula Calculation on datasheet

[VJXXXX]

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!

[Ankesh]

Hi,

please chk the link http://www.sqaforums.com/showflat.php?Ca...ain=477463

This has simalar issue as like yours for excel formula calculation.

Plz let me know if this does not help.

Regards,
Ankesh