=A2*(B2+C2)
for example if a share price is $5 and comission is �1 per share, then for 4 shares the total price would be �24
the above formula works
Note the use of parenteses or brackets (which ever they are called)
any calculation enclosed in () is done first,
i.e anything in column 2 and 3 and multiplied by the value in 1
Hope this is what you were looking for
Paul
Dale Stanchfield wrote:
On Wed, 2005-04-06 at 21:28 +1000, Brian wrote:
Dale Stanchfield wrote:
I am trying to do simple calculations in a spread sheet. Example: Colume A is the number of shares. Column B is the buying price. Column C is the brokers commission. Column D is the cost basis or total cost of buying the stock. I would like to insert the values in columns A, B, and C and have the program calculate the value of column D. In other words, A *B+C=D. My problem is I can't seem to find the proper format to type into the formula bar. I have spent hours looking in the help sections, but I am getting nowhere. I would appreciate any help.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
