I have a spreadsheet which is used to sign in and out of an office. I would like to be able to put a summary at the top of the page. So I am chasing a formula's. I'll explain:
Column A=date
Column B=Staff Name
Column D=Time Returning
Column E=Yes/No (this is to indicate a vehicle has been taken)
Formula I need help with. all criteria will be on the same row.
1. If column A = today & column B = Brian & column D = less than current time then cell with formula says Yes.
2. If column A = today & column B = Brian & column D = less than current time & colun E = yes then cell with formula says Yes.
These would be two different cells with the two different formula.
If anyone can help it would be appreciated.
Column A=date
Column B=Staff Name
Column D=Time Returning
Column E=Yes/No (this is to indicate a vehicle has been taken)
Formula I need help with. all criteria will be on the same row.
1. If column A = today & column B = Brian & column D = less than current time then cell with formula says Yes.
2. If column A = today & column B = Brian & column D = less than current time & colun E = yes then cell with formula says Yes.
These would be two different cells with the two different formula.
If anyone can help it would be appreciated.