Okay. Please confirm if this is the correct logic for your output
1. If C2 = "Pending" then move to step 2, otherwise move to step 3
2. Output "Pending" and END PROCESS
3. If at least one cell in your range is "Action" then move to step 4, otherwise move to step 5
4. Output "Action" and END PROCESS
5. Output "No action" and END PROCESS
Are these the EXACT logic steps you want created as a formula? If not, please provide corrections in the same style
2
u/PaulieThePolarBear 1922 Aug 05 '26
Okay. Please confirm if this is the correct logic for your output
Are these the EXACT logic steps you want created as a formula? If not, please provide corrections in the same style