jeudi 7 juillet 2016

Using multiple IF statements in the same cell

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;

enter image description here

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;

enter image description here

Aucun commentaire:

Enregistrer un commentaire