Monday Tuesday Wednesday Thursday Friday
09:00 - 11:30 ALL
11:30 - 13:00 Elliot Marc Marc Vera Vera
13:00 - 15:30 Marc FALSE FALSE FALSE FALSE
15:30 - 17:00
1 2 3 3 2
1 1 1 2 2
Formula for Tuesday =If(D5 = "Elliot",Choose(H10,"Marc","Vera",elseif(D5 = "Marc", Choose(H10,"Elliot","Vera"),elseIF(D5 = "Vera",Choose(H10,"Marc","Elliot"))))) Formula for the rest =If(F5 = "Elliot",Choose(J10,"Marc","Vera",if(F5 = "Marc", Choose(J10,"Elliot","Vera"),IF(F5 = "Vera",Choose(J10,"Marc","Elliot")))))
Any ideas why its returning False? it returns "Marc" on Tuesday due to the first IF query being correct but if incorrect it doesn't move onto the next if query?
Aucun commentaire:
Enregistrer un commentaire