I would like to multiply a column based on one of two values, depending upon whether or not a boolean value is true or false. Specifically, if I select Used as true, I would like my margin to be multiplied by .35. Otherwise, if it is false, then I would like my margin to be multiplied by .3. I would like both of these answers to be entered into my Commission column.
I wrote a macro, though it is not entering the data: REM ***** BASIC ***** Sub Main If Used = False Then Commission = Margin*.35 Else Commission=Margin*.3 End Sub Thoughts/suggestions/guidance? -- Eric Meyer NW Kansas Ag-Chem Representative LDI 1366 Toulon Avenue Hays, KS 67601 785-735-4355 Fax: 785-301-2421
