Multiplying in Open Office - Calculator
Results 1 to 2 of 2

Thread: Multiplying in Open Office - Calculator

  1. #1
    Join Date
    Jul 2000
    Location
    by the sea, by the sea...
    Posts
    543

    Multiplying in Open Office - Calculator

    I need to multiply all the numbers in column C times 0.91 (or 91%) to arrive at the correct number for all the numbers in column D. I am able to do that one at a time, but I seem to recall that years ago when I used Microsoft Excel that I could just do a shift and down arrow and do a formula that would hold for the whole spreadsheet. Is there any way to do a similar thing with Open Office Calculator, or am I stuck with having to do each line separately?

  2. #2
    Join Date
    Mar 2009
    Location
    Arkham Asylum, Cell 13
    Posts
    11,686
    I think you mean Calc, not calculator. What version of OpenOffice? I have LibreOffice, which is similar.

    So you're making a formula to multiply the C column by .91? For example, in the D1 cell, you could type =C1*.91. Then hover the cursor over the bottom right corner of the D1 cell until it changes to a +. Then just drag down to copy the formula to the lower cells.

    If that's not it, please clarify. A screenshot would help.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •