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
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.