How to get intermediate value of cell formula

J

jaimin jani

I would like to have function that can give intermediate value of cell
formula, and not the actual formula

I got one such function named gfrv() in this group at below given link
http://groups.google.com/group/micr...9a88c20?hl=en&lnk=gst&q=gfrv#7e8a8c16d9a88c20

but it does not work for ranges and some other functions like "IF". It
gives formula instead of intermediate result in case of ranges.

this formula uses regular expression for extracting values.

I would like to know how this can be modded for working with ranges
 
J

Joel

You code will not work on functions that have multple pieces like IF and it
won't work on nest functions. You need a recusive algorithm that will break
the code into pieces and the take each piece and and cal the functtion again.
You wil need to make a table off all the excel functions. there arre
programs like LEX and YACC

see this webpage in the sections LEX and YACC.

http://netlib.bell-labs.com/7thEdMan/v7vol2b.pdf
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select All checkboxes 5
get value of cell only 6
use vlook to show the value of a cell using a formula 5
'Autofill' macro for range of checkbox cell links 1
return a formula instead of a value of a cell 4
Cell reference in formula as range 4
Add the actual value in a cell that contains a formula 3
how do i show the calculated value in a cell rather than formula 3

Top