Site Map - skip to main content - dyslexic font - mobile - text - print

Hacker Public Radio

Your ideas, projects, opinions - podcasted.

New episodes Monday through Friday.


Our hosting is kindly provided by Josh from AnHonestHost.com. We would appreciate it if you could donate to help reduce his costs in funding the hosting.
He is also accepting bitcoins to 1KsxJr9HtsdaUeU7yaV9bk9bQi21UPBtUq

hpr1495 :: 27 - LibreOffice Calc - Calculations and the Formula Bar

This episode looks at the creating and using formulas in spreadsheets.

<< First, < Previous, Latest >>

Host Image
Hosted by Ahuka on 2014-04-25 is flagged as Clean and is released under a CC-BY-SA license.
Listen in ogg, spx, or mp3 format. | Comments (1)

Part of the series: LibreOffice

In this in-depth series on LibreOffice we examine Writer, Calc and Impress

Since the main purpose of a spreadsheet is to perform calculations it is appropriate that we consider just how this is done.

In general, a cell of a spreadsheet can contain one of three things:

  • A number
  • Text
  • A formula

All calculations are done using formulas. A formula occurs whenever a cell has contents that begin with an equals sign, which is the signal to Calc that it needs to perform a calculation. For instance, if a cell contains "A3+B3", Calc would examine this, see the letters and the plus sign, and decide that the contents of the cell were a text string. After all, it cannot be a pure number with those other things there. But place an equals sign in front, so that the contents now read "=A3+B3" and Calc knows that this is formula, and will perform the calculation. And one of the best ways to interact with a cell that contains a formula is to use the Formula Bar, which normally appears just above the cells of the spreadsheet proper:

For the remainder of the show notes please read: http://www.ahuka.com/?page_id=723


Comments

Subscribe to the comments RSS feed.

Comment #1 posted on 2014-04-25T19:18:03Z by anon

This guy sounds like a teacher. He should produce online video courses.

Leave Comment

Note to Verbose Commenters
If you can't fit everything you want to say in the comment below then you really should record a response show instead.

Note to Spammers
All comments are moderated. All links are checked by humans. We strip out all html. Feel free to
record a show about yourself, or your industry, or any other topic we may find interesting. We also check shows for spam :).

Provide feedback
Your Name/Handle:
Title:
Comment:
Anti Spam Question: What does the P in HPR stand for ?
Are you a spammer →
Who hosted this show →
What does HPR mean to you ?