Menu

How in to parse constants in formula to cells

Search this Thread

Prev

Previous Post

Next Post

Next

#24

Report Post

Posted to microsoft.public.excel.programming

Ron Rosenfeld Ron Rosenfeld is offline

Ron Rosenfeld is offline

external usenet poster

Posts: 5,651

Default

How in to parse constants in formula to cells

On Sun, 26 Nov 2006 04:00:10 GMT, wrote:

Ron,

Could you be more specific with your comment:

"However, it would need to be extended to take care
of the worksheet function issue I raised earlier."

Other than my error with the Round worksheet function argument,
I am not sure what you mean.

Thanks, EagleOne

You mentioned in an earlier post that did NOT want to return the values that
were used as function criteria, such as num_digits in the ROUND function.

There are a number of functions with similar criteria.

For example, range_lookup in the various LOOKUP functions (which can be
expressed as 0, 1, TRUE or FALSE)

match_type in the MATCH function

decimals & no_commas in the FIXED function

etc.

There's no general rule of which I am aware that can differentiate a number
that is a function argument versus a number that the function is operating on.
So unless someone comes up with something, you'd have to look at every
function, and only return the value that is in the appropriate location.

--ron

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula constants?	Glenn L.[_2_]	Excel Worksheet Functions	2	August 29th 08 01:47 PM
Copying formula cells that really ought to be constants?	Nate[_4_]	Excel Programming	8	April 27th 06 01:52 PM
How do I capitalize and parse in the same formula?	blondegreenjeans	Excel Worksheet Functions	2	December 8th 05 01:57 AM
How do you copy a formula without incrementing some constants?	JohnT	Excel Worksheet Functions	2	February 18th 05 11:09 AM
Parse formula	Don Guillett[_4_]	Excel Programming	2	January 21st 04 10:07 PM

All times are GMT +1. The time now is 12:40 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement