Index Formula Question?

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.
 
C

Chip Pearson

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
 
Top