NeoOffice: Multiplying cell contents in 2 columns

macmaniacmacmaniac
Posted:
in Mac Software
In NeoOffice spreadsheet, I need to multiply the contents of cells in two columns and display the result in a third, preferably using the column heading. Is this possible and how do I do it?
Thank you

Comments

  • Reply 1 of 1
    MarvinMarvin Posts: 15,431moderator
    macmaniac said:
    In NeoOffice spreadsheet, I need to multiply the contents of cells in two columns and display the result in a third, preferably using the column heading. Is this possible and how do I do it?
    Thank you
    If the columns are A, B, C and row is 1, in C, write =A1*B1 and hit enter. That will multiply the first two columns. Then select all the rows in C including the one you entered and use the "fill down" command. Not sure of the menu item in NeoOffice but it should show up using the help menu. Possibly Sheet menu > Fill Cells > Down.
Sign In or Register to comment.