mardi 25 octobre 2016

Nested if function showing "False"

    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