[SOLVED] Calculation

Questions about applications and software
Forum rules
Before you post please read how to get help
Post Reply
BoDill
Level 4
Level 4
Posts: 315
Joined: Thu Apr 10, 2014 4:31 pm

[SOLVED] Calculation

Post by BoDill » Fri Jan 05, 2018 3:09 pm

I have set up a table using Libre Office Calc, and would like to have a column (Column D) that takes numbers from two other columns (Column B and Column C) and does a mathematical calculation (Column C/Column B) to get a decimal answer to two or three places, but cannot figure out how to do it. Sincerely, I have spent hours trying different things and so far nothing works. Can you help me?

Thank you in advance,
BoDill
Last edited by Moem on Fri Jan 05, 2018 4:56 pm, edited 1 time in total.
Reason: Marked this as [SOLVED] for you; please note that you can do this for your own topics. Thanks!
Dell Optiplex GX520 with Linux Mint 17 'Qiana' MATE 32bit, Kernel:3.13.0-24-generic i686 (32 bit) DESKTOP: N/A

trapperjohn
Level 5
Level 5
Posts: 813
Joined: Wed Jul 11, 2012 4:10 pm
Contact:

Re: Calculation

Post by trapperjohn » Fri Jan 05, 2018 3:19 pm

for the first column:

=C1/B1

then drag it down

BoDill
Level 4
Level 4
Posts: 315
Joined: Thu Apr 10, 2014 4:31 pm

Re: Calculation

Post by BoDill » Fri Jan 05, 2018 4:49 pm

Thank you very much!!!!! It worked instantly!!

As you can probably guess; I'm not real good at this stuff.

BoDill
Dell Optiplex GX520 with Linux Mint 17 'Qiana' MATE 32bit, Kernel:3.13.0-24-generic i686 (32 bit) DESKTOP: N/A

Post Reply

Return to “Software & Applications”