Spread sheet formulas

Tags:
Microsoft Excel formulas
Open source software
How do I set up spread sheet formulas. The help section that came with the software is useless to me as it is much too technical. Our children's charity nonprofit runs off one PC, and being able to use the spread sheet would be wonderful instead of making up documents adding on a calculator for hours and then putting it a word style document for our records.

Answer Wiki

Thanks. We'll let you know when a new response is added.

Try looking for some online Excel tutorials. The concepts are the same in most spreadsheet programs. The general functions are about the same but may have a slightly different name and that is where the online help would be useful in seeing what the function name is in one spreadsheet program vs another.

One online Excel tutorial resource I found is at <a href=”http://mistupid.com/tutorials/excel/”>MIStupid.com</a>
<a href=”http://www.usd.edu/trio/tut/excel/1.html”>Another tutorial</a>

————————————

I think you will need to specify the “brand” or “name” of the spread sheet program, since you included an ‘excel formulas’ tag, but also an ‘open source applications for linux’ tag.

If the pc is running linux, it could be Star Office, or Open Office, which are pretty similar to Excel.

In general, to write a formula, you need to start with the equal sign (=), for example, to compute a sum for a range of cells (say from A3 to A7), you would write this formula:

=sum(A3:A7)

or you could write this:

=A3+A4+A5+A6

Usually you do not need to write the cell names, but select them with the mouse.

You might want to take a look at these pages:

<a href=”http://www.free-training-tutorial.com/animations/formulas-basics.html”>The very basics of formulas</a>
<a href=”http://office.tizag.com/excelTutorial/excelformulas.php”>Excel Formulas</a>

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Linux - Ask the Expert
    The questioner provided this additional information about the program: It is sun micro systems open office the question was about the program included in it called Calc. I have been able to get it to add and can manually make it subtract but have no idea how to set up a formula for a column. Thanks for the help.
    270 pointsBadges:
    report
  • Leah Rosin
    I found a help with StarOffice Calc page, and the instructions for setting up a formula are copied here: To Create a Formula 1. Click in the cell where you want to display the result of the formula. 2. Type =, and then type the formula. For example, if you want to add the contents of cell A1 to the contents of cell A2, type =A1+A2 in another cell. 3. Press Return. I would take a look there, hopefully they are less complicated than in the original instructions.
    575 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following