Forum Discussion
If statement. If one cell of 5 is changed to true.
I'm new to excel and I am trying to figure out a formula. I have 5 cells. e.g. True, True, False, False, False. These are for Monday, Tuesday, Wednesday etc. Every day at work we get info. If th...
If I understand the goal correctly, you can use an IF-OR
=IF(OR(A2:E2),"Not collected","Collected")If there's at least one TRUE in A2:E2 the OR resolves to the 'true' argument and "Not collected" is returned. If FALSE is present in all cells then "Collected" is returned.
- Hi,
Thank you!
Tried this and it worked for what you said the problem im having now is that if its "Collected on a Tuesday then because it was "Not collected" on Monday it will say "Not Collected" for the whole week. But thank you. Got me 1 step closer- Are you able to provide a sample workbook? Your goal is not entirely clear to me.
