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
 
Back
Top