Posted to microsoft.public.excel.misc

external usenet poster

Posts: 50

Formula vs. Constant

Is there a way using excel funtions (not UDF) to find if a cell contains a
formula vs. a number (constant).
I looked around the forum but did not find anything. I tried using cell
function and left function but they return the value in the formula itself.
Any help is appreciated.
Regards,
RK

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
Constant in Excel Formula	Chele	Excel Worksheet Functions	3	April 18th 09 12:34 AM
Writing a formula with a constant	Barb	Excel Discussion (Misc queries)	2	September 10th 08 01:47 PM
Set a constant from a formula in VBA	Ed	Excel Discussion (Misc queries)	1	December 1st 06 01:31 AM
Formula Constant	dale1948	Excel Worksheet Functions	2	November 2nd 05 09:44 PM
Constant Value in formula.	Nomad	Excel Worksheet Functions	1	March 28th 05 08:53 PM

All times are GMT +1. The time now is 12:47 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us