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

​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 senseSorry its hard to explain i’m extremely new to excel.Thank you  Read More

​