I need help getting LibreOffice Calc to accept a simple math function, =E1+G2-F2 and use it.
Can someone point me to a good instruction for entering it? I simply want to add two columns, E and G, and subtract F. I've done this before with out a problem, can't seem to make it work in a new install ...
Bob
I'm running 6.2.6.2 of Calc. The calculations work as expected. The formula is =E1+G2-F2 which equals 6
Col E F G 1 5 3 4 2 6 4 5
On Sun, Sep 1, 2019 at 1:30 PM Bob Goodwin bobgoodwin@fastmail.us wrote:
I need help getting LibreOffice Calc to accept a simple math function, =E1+G2-F2 and use it.
Can someone point me to a good instruction for entering it? I simply want to add two columns, E and G, and subtract F. I've done this before with out a problem, can't seem to make it work in a new install ...
Bob
-- Bob Goodwin - Zuni, Virginia, USA http://www.qrz.com/db/W2BOD box10 FEDORA-29/64bit LINUX XFCE Fastmail POP3
users mailing list -- users@lists.fedoraproject.org To unsubscribe send an email to users-leave@lists.fedoraproject.org Fedora Code of Conduct: https://docs.fedoraproject.org/en-US/project/code-of-conduct/ List Guidelines: https://fedoraproject.org/wiki/Mailing_list_guidelines List Archives: https://lists.fedoraproject.org/archives/list/users@lists.fedoraproject.org
On 9/2/19 4:29 AM, Bob Goodwin wrote:
I need help getting LibreOffice Calc to accept a simple math function, =E1+G2-F2 and use it.
Can someone point me to a good instruction for entering it? I simply want to add two columns, E and G, and subtract F. I've done this before with out a problem, can't seem to make it work in a new install ...
I do not know what you want to do based on the words you've used.
You say "columns", but the elements E1, G2, and F2 define "cells". With the letter designating the "column" of the cell and the number the "row" of the cell.
Why don't you place you're calc file some where for folks to look at it?
On 09/01/19 17:28, Ed Greshko wrote:
Why don't you place you're calc file some where for folks to look at it?
I don't know how to respond to that. LibreOffice calc loos like one big GUI to me. I can't find a text config. file to offer?
On 9/2/19 5:48 AM, Bob Goodwin wrote:
On 09/01/19 17:28, Ed Greshko wrote:
Why don't you place you're calc file some where for folks to look at it?
I don't know how to respond to that. LibreOffice calc loos like one big GUI to me. I can't find a text config. file to offer?
When you save your work you get a file called "something.ods" (normally).
Put that file on google drive or someplace for people to download.
On 9/2/19 5:51 AM, Ed Greshko wrote:
On 9/2/19 5:48 AM, Bob Goodwin wrote:
On 09/01/19 17:28, Ed Greshko wrote:
Why don't you place you're calc file some where for folks to look at it?
I don't know how to respond to that. LibreOffice calc loos like one big GUI to me. I can't find a text config. file to offer?
When you save your work you get a file called "something.ods" (normally).
Put that file on google drive or someplace for people to download.
You can get the file is_this_it.ods using this link
https://drive.google.com/file/d/1MplVir1dNx0w2nF9--dS_-AqfcH7YlWl/view?usp=s...
Google Drive is "smart" and opens it in "Google Sheets". So you will need to download it and open it in Calc to see the work.