Posted to microsoft.public.excel.misc

Faraz A. Qureshi Faraz A. Qureshi is offline

external usenet poster

Posts: 211

INDIRECT FUNCTION

I have a A1 with a formula ="+2+2"
I thought =INDIRECT(A1) would reflect 4 whereas it is returning #Ref!
How to carryout the desired function?
--
Thanx & Best Regards,

Faraz!

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
trying to use Indirect function	Eric_in_EVV[_2_]	Excel Worksheet Functions	5	December 2nd 09 06:51 PM
Using INDIRECT Function and INDEX Function	ChristopherG	Excel Discussion (Misc queries)	1	June 10th 09 04:07 PM
How to use indirect function?	Eric	Excel Discussion (Misc queries)	2	November 20th 08 05:17 AM
Indirect function	andy	Excel Worksheet Functions	3	June 28th 07 07:40 AM
INDIRECT function inside AND function	Biff	Excel Worksheet Functions	3	September 23rd 06 07:20 PM

All times are GMT +1. The time now is 06:34 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us