I have this if statement that calculates a due date for me, it works fine but I now have a new situation that created the need to modify to exclude the calculation if column E contains the work "Broker".
=IF(K21<>"","N/A",IFERROR(WORKDAY.INTL(N21,-3,11,Holidays!$D$5:$D$26),""))
Here is what I have tried but it gives me an error, what am I oding wrong?
=IF(K21<>"",if(e21,"<>*brokered*"),"N/A",IFERROR(WORKDAY.INTL(N21,-3,11,Holidays!$D$5:$D$26),""))
=IF(K21<>"","N/A",IFERROR(WORKDAY.INTL(N21,-3,11,Holidays!$D$5:$D$26),""))
Here is what I have tried but it gives me an error, what am I oding wrong?
=IF(K21<>"",if(e21,"<>*brokered*"),"N/A",IFERROR(WORKDAY.INTL(N21,-3,11,Holidays!$D$5:$D$26),""))