Hi.
I have a condition where I want to create a nested IF statement that takes into account multiple OR conditions with data in various adjacent and non-adjacent cells. I need something like the literal statement below, that can be easily appended, if I decided to add other cells/criteria.
=IF (C8 ) contains "INF-" OR IF (C8) contains "Main" or IF (F9) equals "(blank)" OR IF (F9) = "XXXXXX", "Don't Count", "Count")
thanks in advance for any solutions/advice...!
I have a condition where I want to create a nested IF statement that takes into account multiple OR conditions with data in various adjacent and non-adjacent cells. I need something like the literal statement below, that can be easily appended, if I decided to add other cells/criteria.
=IF (C8 ) contains "INF-" OR IF (C8) contains "Main" or IF (F9) equals "(blank)" OR IF (F9) = "XXXXXX", "Don't Count", "Count")
thanks in advance for any solutions/advice...!