New To UFT? Join the best UFT Training Online!

Micro Focus QTP (UFT) Forums › Micro Focus UFT (earlier known as QTP) › UFT / QTP Beginners v
Excel Formula Calculation on datasheet

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Thread Modes
Excel Formula Calculation on datasheet
VJXXXX Offline
Junior Member
**
Posts: 1
Threads: 1
Joined: Oct 2011
Reputation: 0
#1
Solved: 10 Years, 9 Months, 1 Week ago 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!
Find
Reply


Messages In This Thread
Excel Formula Calculation on datasheet - by VJXXXX - 10-29-2011, 08:45 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  How import final calculated values by cell formula from Excel not the formula itself. qtped 1 4,717 01-17-2017, 04:05 PM
Last Post: sagar.raythatha
  Storing runtime value into datasheet priyaUFTlearner 4 3,202 04-10-2015, 10:08 PM
Last Post: priyaUFTlearner
  Error with QTP DataSheet Values. srach84 1 2,004 11-27-2014, 10:32 AM
Last Post: vinod123
  Way to take values from datasheet and output Fairbanks 3 2,907 03-27-2014, 07:18 PM
Last Post: Ankur
  Import and read multiple tabs on a datasheet trance07 1 3,116 10-09-2013, 07:29 PM
Last Post: Parke

Forum Jump:


Users browsing this thread: 1 Guest(s)