Posts: n/a

Jason Morin wrote...
XLM:

1. Press Ctrl+F3 and define a name "isformula" (no quotes)
as:

=LEFT(GET.FORMULA(INDIRECT("RC[-1]",FALSE)))="="
....

In what conceivable alternative universe would this be preferable to
=GET.CELL(48,INDIRECT("RC[-2]",0))

?!

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
inserting data from a row to a cell, when the row number is specified by a formula in a cell	[email protected]	New Users to Excel	2	January 6th 05 07:18 AM
looking for a formula	Amanda	Excel Worksheet Functions	5	January 5th 05 07:37 AM
How can I write an if-then formula for 0 or less than 0 in cell t.	Baz1	Excel Worksheet Functions	1	November 30th 04 04:33 PM
GET.CELL	Biff	Excel Worksheet Functions	2	November 24th 04 07:16 PM
Cell doesn't show formula result - it shows formula (CTRL + ' doe.	o0o0o0o	Excel Worksheet Functions	6	November 19th 04 03:13 PM

All times are GMT +1. The time now is 02:10 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us