Excel Nested Formula

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
How about some thing like this

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