rhonllanders
New Member
- Joined
- Mar 21, 2023
- Messages
- 12
- Office Version
- 365
- Platform
- Windows
Hello! I am trying to figure out how to correctly write a formula that will look for the word TRUE in 2 different ranges. If there is a TRUE anywhere in either range, then it would return the text "TRUE"
Here was my best shot so far and it's a no go...
'=IF(OR(COUNTA(AF47:AF90)="True",IF(COUNTA(AF137:AF150)="True"),"TRUE"))
Can you help?
Thanks so much in advance.
Here was my best shot so far and it's a no go...
'=IF(OR(COUNTA(AF47:AF90)="True",IF(COUNTA(AF137:AF150)="True"),"TRUE"))
Can you help?
Thanks so much in advance.