View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michael168[_67_] Michael168[_67_] is offline
external usenet poster
 
Posts: 1
Default 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/