Can someone help me!? I have a workbook that has a very long formula in 576 different cells. It is a football picks spreadsheet that tracks points based on winners and losers. It works for all Excel programs after 2003 version, but some of the users that I send it to have the older versions that do not allow as many characters for the formulas, or as many calculations. Here is an example of one cell's formula. Can you help me consolodate it to where it will work in previous versons of Excel?
=IF((B3=Sheet2!$A$2),$I3,IF((B3=Sheet2!$A$3),$I3,IF((B3=Sheet2!$A$4),$I3,IF((B3=Sheet2!$A$5),$I3,IF((B3=Sheet2!$A$6),$I3,IF((B3=Sheet2!$A$7),$I3,IF((B3=Sheet2!$A$8),$I3,IF((B3=Sheet2!$A$9),$I3,IF((B3=Sheet2!$A$10),$I3,IF((B3=Sheet2!$A$11),$I3,IF((B3=Sheet2!$A$12),$I3,IF((B3=Sheet2!$A$13),$I3,IF((B3=Sheet2!$A$14),$I3,IF((B3=Sheet2!$A$15),$I3,IF((B3=Sheet2!$A$16),$I3,IF((B3=Sheet2!$A$17),$I3,IF((B3=Sheet2!$A$18),$I3,IF((B3=Sheet2!$A$19),$I3,IF((B3=Sheet2!$A$20),$I3,IF((B3=Sheet2!$A$21),$I3,IF((B3=Sheet2!$A$22),$I3,IF((B3=Sheet2!$A$23),$I3,IF((B3=Sheet2!$A$24),$I3,IF((B3=Sheet2!$A$25),$I3,IF((B3=Sheet2!$A$26),$I3,IF((B3=Sheet2!$A$27),$I3,IF((B3=Sheet2!$A$28),$I3,IF((B3=Sheet2!$A$29),$I3,IF((B3=Sheet2!$A$30),$I3,IF((B3=Sheet2!$B$2),"W",IF((B3=Sheet2!$B$3),"W",IF((B3=Sheet2!$B$4),"W",IF((B3=Sheet2!$B$5),"W",IF((B3=Sheet2!$B$6),"W",IF((B3=Sheet2!$B$7),"W",IF((B3=Sheet2!$B$8),"W",IF((B3=Sheet2!$B$9),"W",IF((B3=Sheet2!$B$10),"W",IF((B3=Sheet2!$B$11),"W",IF((B3=Sheet2!$B$12),"W",IF((B3=Sheet2!$B$13),"W",IF((B3=Sheet2!$B$14),"W",IF((B3=Sheet2!$B$15),"W",IF((B3=Sheet2!$B$16),"W",IF((B3=Sheet2!$B$17),"W",IF((B3=Sheet2!$B$18),"W",IF((B3=Sheet2!$B$19),"W",IF((B3=Sheet2!$B$20),"W",IF((B3=Sheet2!$B$21),"W",IF((B3=Sheet2!$B$22),"W",IF((B3=Sheet2!$B$23),"W",IF((B3=Sheet2!$B$24),"W",IF((B3=Sheet2!$B$25),"W",IF((B3=Sheet2!$B$26),"W",IF((B3=Sheet2!$B$27),"W",IF((B3=Sheet2!$B$28),"W",IF((B3=Sheet2!$B$29),"W",IF((B3=Sheet2!$B$30),"W",0))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
Thank You!!
Bookmarks