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 the info for one one thing is not there then we put it through as true but when we have the info for that week then we switch it needs to switch to false.
How would I make it so that e.g. on Wednesday the data comes back as false (we get the data) then the if statement changes. At the moment all i've managed to do is make it so if there is any true in the statement then it comes back with "not collected" however if it is "collected" on wednesday it will still say "not collected" as Mon and Tue weren't "collected"
If that makes any sense
Sorry its hard to explain i'm extremely new to excel.
Thank you
Are the cells empty until you know whether data came in on a specific day, or are all five initially TRUE?
- Hi,
They are initially false sorry
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.
Any update?
