User Profile
danielperry11
Copper Contributor
Joined 3 months ago
User Widgets
Recent Discussions
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 you372Views0likes6Comments
Groups
Recent Blog Articles
No content to show