How can I add up 1+1?

Discuss the spreadsheet application
Post Reply
lhkv.utkgjtkftkuutf
Posts: 1
Joined: Fri Nov 29, 2024 2:22 am

How can I add up 1+1?

Post by lhkv.utkgjtkftkuutf »

Just installed Open Office Calc, and I can't figure any of it out. I basically got it to add up multiple numbers to do someone else's taxes (to check the results).

Just for starters, how would I add up 1+1 in Open Office Calc?

I literally spent hours on Google trying to figure it out, and I know less now than when I started. I can't even begin to describe how utterly inscrutable it all is.
OpenOffice 3.1 on Windows 10
User avatar
robleyd
Moderator
Posts: 5265
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: How can I add up 1+1?

Post by robleyd »

Just use this formula:

Code: Select all

=1+1
If you want to add a number of values in contiguous cells, you can use the SUM function; e.g. to add the values in cells A1 to A15

Code: Select all

=SUM(A1:A15)
You might find these references useful:
OpenOffice.org 3 Calc Guide
[Tutorial] Ten concepts that very Calc user should know

Your local library may have a copy of Excel for Dummies, which will cover the basics of spreadsheet use.
Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.8.3.2; SlackBuild for 24.8.3 by Eric Hameleers
---------------------
Roses are Red, Violets are Blue
Unexpected '{' on line 32
.
Post Reply