Hey guys,
I need a formula for the following issue:
the sales tax in a Purchase order i want it to be like that, if it has the word "included" chosen from a drop down menu, then the sales tax cell shall be 0. Otherwise, if "included" is not chosen then sales tax shall be normally calculated.

can anybody help with this problem please ASAP!!

Also the excel sheet is attached.

Thanks in advance.sample mec po 11.xlsx