Posted to microsoft.public.excel.programming

Michael168[_67_] Michael168[_67_] is offline

external usenet poster

Posts: 1

Index Formula Question?

In worksheet2 cell A151, I would like to have below
=IF(COUNT(ISODD(C151)),ISODD(D151),ISODD(E151))=3 ,1,0)

How do I add in the INDEX formula so that it can refer to the cells of
worksheet1?

Thanks for helping.

------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

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
INDEX / MOD() question..	Nastech	Excel Discussion (Misc queries)	1	October 17th 08 08:17 AM
INDEX/MATCH formula question	A.S.	Excel Discussion (Misc queries)	1	January 15th 07 05:23 PM
Question calculation time and Index formula	S Davis	Excel Worksheet Functions	8	November 7th 06 11:41 PM
Index,Matchup Formula Question	JDT	Excel Discussion (Misc queries)	7	April 16th 05 04:44 PM
Lookup/Index formula question.	Barbara	Excel Worksheet Functions	2	December 7th 04 04:45 PM

All times are GMT +1. The time now is 08:31 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us