add formula to cell in openoffice spreadsheet

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

add formula to cell in openoffice spreadsheet

mick howe
been battling to use a simple formula in a spreadsheet to cause each cell
'Fx' to equal the contents of cell 'Ex' of the same row multiplied by the
contents of cell 'Dx'. I have done this in MS Office v2 to v6 and 97, Star
Office on both OS/2 & various Linux versions and libreoffice until version
6.
When I try to do this, either on Linux or win10 I get either no result or
messages along the lines of #error=NAME?, #NAME=#508? or just no result.
I can't see any explanation when I search for the meaning of the error
messages
Even when I tried to open a sheet I did a couple of years ago with very
similar calculations in LibreOffice I experienced the same problems.
Please help, it is doing my head in.

mick in glen innes 2370
Reply | Threaded
Open this post in threaded view
|

Re: add formula to cell in openoffice spreadsheet

David Robley
A simple =D1*E1 placed in F1 should do what you want - assuming that D
and E contain numbers, not text. You can check the type of content in
cells using View | Value Highlighting or the keyboard shortcut Ctrl+F8.
The formula can then be copied or dragged down as needed.

Text cells are formatted in black, formulas in green, and number cells
in blue, no matter how their display is formatted.

Since you are not subscribed to this list you may not see all the
replies to your query. To subscribe to Apache OpenOffice mailing lists
go to http://openoffice.apache.org/mailing-lists.html

As a courtesy I have sent a copy of this reply to you as well as to the
mailing list. Do Not reply to me personally but just to the list at
<[hidden email]> - replies to my personal email address
will be ignored.

On 10/8/20 3:04 pm, mick howe wrote:

> been battling to use a simple formula in a spreadsheet to cause each cell
> 'Fx' to equal the contents of cell 'Ex' of the same row multiplied by the
> contents of cell 'Dx'. I have done this in MS Office v2 to v6 and 97, Star
> Office on both OS/2 & various Linux versions and libreoffice until version
> 6.
> When I try to do this, either on Linux or win10 I get either no result or
> messages along the lines of #error=NAME?, #NAME=#508? or just no result.
> I can't see any explanation when I search for the meaning of the error
> messages
> Even when I tried to open a sheet I did a couple of years ago with very
> similar calculations in LibreOffice I experienced the same problems.
> Please help, it is doing my head in.
>
> mick in glen innes 2370
>

Cheers
--
David Robley

Remember, UNIX spelled backwards is XINU.