Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checking the result of a formula
Hi Steven,
are you looking for the Evaluate method, which evaluates a string as though it was a formula? If so take a look at http://www.decisionModels.com/calcsecretsh.htm which discusses how to use evaluate hth Charles ______________________ Decision Models The Excel Calculation Site www.DecisionModels.com "Steven Revell" wrote in message ... Hi All, Is it possible to check what the result of a formula is within a cell? Cheers, Steven |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checking the result of a formula
I'm looking for something along the lines of being able to determine,
using code, whether a formula result is of a certain value. e.g. =A1/B1 I would want to know whether it is less than 1 and if so then i'd delete the row. Thanks, Steven Revell Applications Development & Support Covance Laboratories Europe, UK *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula result does not match displayed result | Excel Worksheet Functions | |||
Formula Bar F9 Result differs from cell result??? | Excel Worksheet Functions | |||
Spell Checking with checking cell notes | Excel Discussion (Misc queries) | |||
Advanced formula - Return result & Show Cell Reference of result | Excel Worksheet Functions | |||
Median result used in formula gives incorrect result | Excel Worksheet Functions |