I would like a column that displays ISLA, OSLA or N/A which I can then use to create a %age figure against the amount of ISLA entries compared to OSLA based on the data.
I'm not that great at excel and there might be a better way of doing this whole task but I have tried to acheive this with the IF command. It checks if C2 is "available", then checks if it's a Sunday and compares the Time Converted to the relevannt SLA figure - where 06:00 is a weekday and 08:00 is a Sunday. Excel has finally accepted the statement's formatting but it's got the #NAME? error.
My Table currently looks like this;
My IF statement is this;
=IF(C2 = "Available",IF(E2 = "Sunday", IF(D2 > F3, “OSLA”, ”ISLA”), IF(D2 > F2, “OSLA”, “ISLA”)), “N/A”)
The cells in D have this forumula; =--TEXT(B3,"00:00:00")
The insert function on the statement looks like this;
Aucun commentaire:
Enregistrer un commentaire