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