Filling a multiplication chart
With OOo, it is a straightforward task to generate a “data table” that is basically just multiplying a row by a column. So we have percentages running across the top row and dollar amounts down the first column, everything in between we’d like to be the product of that % and dollar amount.
Step 1: Enter the desired dollar amounts in column B and the percentage values in row 2. Enter the following formula in C3: =$B3*C$2. Pay close attention to the notation in the formula.
Step 2: Position the cursor in the lower right corner of C3 and drag downwards. The formulae are adjusted for each cell with only the row number changing on the dollar value.
