I am having a difficult time accomplishing a simple command. Ideally, I would like to enter a value in the "Margin" column and have it calculate a value in the "Commission" column (where the multiplication factor would be dependent upon whether it was new or used).
So, it would be something like, if "new" then take margin *.3 and enter data into commission. If "used" then take margin *.35 and enter data into commission. What is a good resource that I can use or what suggestions do you have? Thanks, -- Eric Meyer NW Kansas Ag-Chem Representative LDI 1366 Toulon Avenue Hays, KS 67601 785-735-4355 Fax: 785-301-2421 -- Eric Meyer NW Kansas Ag-Chem Representative LDI 1366 Toulon Avenue Hays, KS 67601 785-735-4355 Fax: 785-301-2421
