Excel Nested Formula

Closed
Numbers - Jun 8, 2010 at 12:52 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 8, 2010 at 01:56 PM
Hello,



I want to use a nested function to locate and flag data in a separate cell. I currently use a complex formula such as in G6 and down (*example):
=IF(AND(a6>=$a$1,(OR(ISNUMBER(FIND("22",D6)),ISNUMBER(FIND("33",D6)),ISNUMBER(FIND("44",D6)),ISNUMBER(FIND("55",D6)),ISNUMBER(FIND("66",D6)),ISNUMBER(FIND("77",D6))))),"Got You","Missed You")

A B C D E F G 1 30
2
3
4
5
6 31 33 Got You
7 66 11 Missed You
8 15 22 Missed You
9 10 66 Missed You
10 99 77 Got You

can I simplify the OR(ISNUMBER(FIND statement string to only the list of values in one statement versus the multiple OR(ISNUMBER(FIND statements chained together?

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 8, 2010 at 01:56 PM
How about some thing like this

=IF(AND(A6>=$A$1,D6>11, D6<88, MOD(D6,11)=0),"Got It","Missed You")
0