Why does the below formula not work? Any help would be greatly appreciated.
Thanks
=IF(AND(AN10="AIR",AX10="Fri"),AH10+3,IF(AND(AN10= "AIR",AX10="Sat"),AH10+2,IF(AND(AN10="AIR",OR(AX10 ="Mon",AX10="Tue",AX10="Wed",AX10="Thu",AX10="Sun" )),AH10+1,IF(AX10="Mon",AH10+4,IF(AX10="Tue",AH10+ 6,IF(AX10="thu",AH10+5,IF(AX10="fri",AH10+5,IF(AX1 0="sun",AH10+5,IF(AX10="Will advise",AX10,"")))))))))