Index Formula Question?

  • Thread starter Thread starter Michael168
  • Start date Start date
M

Michael168

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.
 
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),ISODD(Sheet2!E15
1))>=3,1,0)



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Loops 1
Identify even (or odd) rows without toolpak and 'ISEVEN'/'ISODD' ? 3
Index match with multiple criteria(different than usual) 3
matching multiple columns on different worksheets 1
conditional formating with isodd and iseven 14
How do Excel define the application area? 3
returning formula into a cell 7
odd or even number 3

Back
Top