Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Index Formula Question?
Michael,
I'm not sure what your question is, nor why the INDEX function might be involved. You can get the formula to take values from Sheet2 by changing the formula to =IF(COUNT(ISODD(Sheet2!C151)),ISODD(Sheet2!D151),I SODD(Sheet2!E15 1))=3,1,0) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Michael168" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
INDEX / MOD() question.. | Excel Discussion (Misc queries) | |||
INDEX/MATCH formula question | Excel Discussion (Misc queries) | |||
Question calculation time and Index formula | Excel Worksheet Functions | |||
Index,Matchup Formula Question | Excel Discussion (Misc queries) | |||
Lookup/Index formula question. | Excel Worksheet Functions |