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
<users@openoffice.apache.org> - 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.
