Require a formula to apply a Tax calculation based on vendor status.
EG, If a vendor is registered, a tax calculation (10%) is charged on the base price, if not registered no calculation to be applied.
Formula resides in G3 for the Tax amount.
Where "A3="Yes or “No”
E1= Invoice Amount
Simple task I know but just cant Ragic to emulate an excel formula.
Any help would be appreciated.