Hi guys,

I'm using nested IF statements to return the department and time various employees are working at a bakery.

My formula to return the time they're working returns a FALSE rather than the shift time and I'm having a hard time working out why - help would be greatly appreciated!

Cheers,
Alex

Fairbank roster summary page.xlsx