If function problem
I've put together a table of products that we sell into the reseller market. Currently there are two manufacturers products listed.
I want to give our resellers different discounts depending on which product.
In the table I have a trade price field. I want to say If the product comes from manufacturer x then the discount is say 30%. If the product is from manufacturer y then the discount is 40%.
I have tried to put an initial calculation in the Trade Price field for one of the manufacturers
If ( manufacturer ; Yellow;30;0) however this doesn't work. I get an error message saying. I think for the second manufacturer I need a nested If.
I would appreciate some help here.