Hello Eric, two comments:
1.) In general there is no reason to store calculated values in a databse. 2.) the basic programm doesn't contain informatioens about the data cells which you want to compare or fill. Kind regards Mechtilde Am 23.01.2013 20:29, schrieb Eric Meyer: > 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? > >
signature.asc
Description: OpenPGP digital signature
