Hello All,
I'm having trouble with some IF statements, effectively what I need to do is report peoples time logged in the office. So from 20th of October people should have logged 39 hours, the next week people should have logged 78 hours and so on. Lets say this information is held in cell C54. That's the easy part, I have this formula for that:
=IF(TODAY()>DATE(2014,10,27),(($C$54/B58)*100),A5)
The data is displayed as follows:
<tbody>
</tbody>What I want to do is report the most up to date (based on date of start of the week) percentage to a separate sheet called meeting, so say when it passed the 27th of october it will no longer report the information for the previous week, code example:
=IF(TODAY()>DATE(2014,10,20),Meeting!N40 = CumulativeData!C57, IF(TODAY()>DATE(2014,10,27),Meeting!N40 = CumulativeData!C58, IF(TODAY()>DATE(2014,10,27),Meeting!N40 = CumulativeData!C59,......
I just can't get this to work no matter how many iterations i try
Can anyone help me with this? I hope I have made this clear hahah!
Kind Regards,
Bryan
I'm having trouble with some IF statements, effectively what I need to do is report peoples time logged in the office. So from 20th of October people should have logged 39 hours, the next week people should have logged 78 hours and so on. Lets say this information is held in cell C54. That's the easy part, I have this formula for that:
=IF(TODAY()>DATE(2014,10,27),(($C$54/B58)*100),A5)
The data is displayed as follows:
Date | Hours To Date | Compliance |
20Oct14 | 39 | 67 |
27Oct14 | 78 | 33 |
03Nov14 | 117 | 22 |
10Nov14 | 156 | 0 |
17Nov14 | 195 | 0 |
24Nov14 | 234 | 0 |
01Dec14 | 273 | 0 |
<tbody>
</tbody>
=IF(TODAY()>DATE(2014,10,20),Meeting!N40 = CumulativeData!C57, IF(TODAY()>DATE(2014,10,27),Meeting!N40 = CumulativeData!C58, IF(TODAY()>DATE(2014,10,27),Meeting!N40 = CumulativeData!C59,......
I just can't get this to work no matter how many iterations i try
Can anyone help me with this? I hope I have made this clear hahah!
Kind Regards,
Bryan