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

# Please support our Patrons

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
Please also consider supporting the https://archive.org/donate/ who are now hosting our media files. Right now, a generous supporter will match your contributions 3-to-1. So your \$5 donation results in \$20 for the Internet Archive.

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

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

Hosted by Ahuka on 2014-04-25 is flagged as Clean and is released under a CC-BY-SA license.
Tags: LibreOffice, Calc, Spreadsheet, formulas.
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

##### 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 → Yes No Who hosted this show → Select a Host@einebiene2BFrankA Shadowy FigureAaressaarAccipiterAdamAhukaAkranisAlAlek GrigorianAlk3Alpha32AmunizpAndrew ConwayaparanoidshellArcher72arfabArigornStriderAukonDKb-yeezib1ackcr0wBarimanBeezabeniBetobgryderclockBill "NFMZ1" MillerBill_MIBitboxBitviperbjbblackmathBlackratchetBob EvansBob TregilusBob WoodenBobJonkmanbobobexbookewyrmmBrad CarterbrianBrian in OhioBroamBrocktonBobbrother mouseBrotherredccmusiqueChadCharles in NJcheeto4493Chess GriffinChristopher M. HobbsCibola JerrycidcjmclackeClaudio MirandacleaveyClinton Roycobra2code.cruncherCoder365coldstealcorenominalCottonballsCovCurbuntuCurtis Adkins (CPrompt^)cyanCybercodDannDarkShadowDaveDave MorrissDave YatesDavid WhitmanDavid WillsondawDeb NicholsondeepgeekDeltarayDelwindf99diablomarcusDick ThomasDigital ManiacDismal ScienceDismal Science and Sunzofman1DjBoodmfreydodddummyDominic UilanoDoorToDoorGeekdosmanDospoddoubiDoug FarrellDownerDr^ZigManDrake AnubisDravendroopsdual_parallelDude-mandwickEC LugElectromanelelEmilien KleinEnigmaEpicanisEric DuhamelFacemanFamicomanfawkesfyreFiftyOneFiftyFinfinuxfinux and code.cruncherFlaviu SimihaianfolkyFrank BellFrederic CouchetfthGabriel EvenfiregarjolaGeddesGeoNineGermGNULinuxRTMgoibhniuguitarmanhandsome_pirateHannah, of Terra, of SolHaqHeisenbugHelvetinHonkeymagooHPR VolunteersHPR_AudioBookClubimahuphInsciusIrongeekIronic SodiumJ-HoodJ. A. MathisJames Michael DuPont (h4ck3rm1k3)janedocJared MayesJason ScottjavatardJBu92jelkimantisJeremyJezraJezra and NYbillJoeJoe WakumaraJoelJoey HessjohanvJohn DuarteJohninscJon DoeJon KulpJonathan NadeauJosh KnappjrobbJrulloJulian NeuerJustMeJWPKeith MurrayKen FallonKevieKevin BenkoKevin GranadeKevin WisherKFiveKillersmurfkitcheklaatuKn1ghtl0rdknightwiseKnoxkotrinkurakuraKynan DentL3pprd/ocCodelaindirLinLinlivindedLord DrachenblutlostnbronxLowtek MystikLuminaireLunarsphereLyle Lastingerm1rr0r5h4d35MadjimisimiMadRushmarcozMark ClarkeMark Katerberg and Courtney SchauerMark WatersMatt McGraw (g33kdad)matthewmattkingusaMc FrontalotMC SmedleyMerkMessymanMetatronMichael Foord Michal CieraszynskiMike HingleyMike RaymirovengimirwiMongomonsterbMoral VolcanomordancyMorgellonMPardoMrEMrGadgetsMrsXokeMrXMubixN50Nacho JordiNeandergeekNeodragonNewAgeTechnoHippieNido MedianjuliannoplacelikeslashhomenorristNYbillNYbill and WindigoOnlyHalfTheTimeoperat0rp0trill0patPatrick L ArchibaldpegwolePeterPeter64PhilipPhizonePhreakerD7PipeManMusicpixel JuicePixelfiendPlexipokeyponyboypope523pyrrhicQuvmohReg ARho`nRichard HughesriddleboxRiley Gelwicks (glwx)RillriscphreerkirkRoadrunnerRobin CatlingrootoutcastrowinggolferRujiRuss Wennersaras foxScedhaschismscriptmunkeeScynerSealSeeteesemioticroboticShane Shennansigflupsikilpaake and badbitSilverSkirletskryeslick0Slurrysp0russp0rus and biosshadowspacemanspaceoutspiffytechStankDawgSteve BickleSteve SanerSteve SmethurstStilvoidStitchSunzofman1Svenswift110tcucTgtm News TeamThaj SaraThe Air Staff of Erie Looking ProductionsThe Alien Brothers Podcast (ABP)The BishopThe Linux Experimentthe_remoraTheDUDEthelovebugthewtexThistlewebThoughtPhreakerthreethirtytmacuk Toby MeehanTodd MitchellToeJetTony Hughes AKA TonyH1212Tony PelaezTottenkophTracy Holz_HolzsterTrixtertuturtoUberChickUnderrunerUrban KoistinenUTOSCVarious Creative Commons WorksVarious HostsvenamW3lshrarebitweexwilljasenWindigoWintermute21x1101XcaliburXokeZachZachary De Santos What does HPR mean to you ?