PC Help Forum - Free Computer Help, Windows, Hardware, Software and more!
 
Become a Member Today!
Search PC Help Forum for Answers
 
Go Back   PC Help Forum - Free Computer Help, Windows, Hardware, Software and more! > The Important Stuff > Tutorials > General Application Tutorials
General Application Tutorials - How do I use formulas in Excel? posted in the Tutorials forums; Using Excel Formula Bar ... Excel has a large variety of embedded equations to help make your life easier when it comes to spreadsheet functions. The list of Excel functions is ...

REGISTER NOW to remove these Ads

Comment
 
LinkBack Tutorial Tools Display Modes Language
How do I use formulas in Excel?
Published by merlin
08-01-2005
Default How do I use formulas in Excel?

Using Excel Formula Bar ...

Excel has a large variety of embedded equations to help make your life easier when it comes to spreadsheet functions. The list of Excel functions is too large to place here. However, a quick search of Excel's help file under functions should give you the option to pull up the category lists of functions.

Functions are generally named with what they do, are in all caps, and follow this format:
Say you want to sum up a row of cells from A2 to A8. The function would be =SUM(A2:A8) = alerts Excel to the point of a function, SUM (or whatever) is the function call, and the paranthesis list off the argument list, which could be numbers, cell addresses, or even other functions.

Functions include most mathematical functions. From Trignometry (SIN, COS, TAN, ATAN, etc.) to logical functions (AND, OR, work on checking boolean values of a set of cells) to regression curves and placing today's date (TODAY()) on top of a spreadsheet. Asking for a list of function by category in Excel Help is probably the easiest way to search through the system.

Common formulas include

=SUM(cell:cell) or =SUM(number1, number2, etc) up to 30. Sums a bank of numbers.
=exp(x) returns e to the x power.
=ABS(number or cell) returns absolute value.
=LOG(number,base) returns logarithm to an (optional) base (default = 10)
=LCM(number1, number2, etc.) returns the least common multiple of a list of up to 30 numbers.
=AVERAGE(cell:cell) returns all values in a range.
=AVERAGE(cell:cell, number1, etc.) returns values in a cell block range, plus extra numbers.
=VAR(cell:cell) Estimates sample variance.
=TODAY() Returns a serial number saying how many days since 1/1/1900
=YEAR(serial number) =DAY(Serial Number) Converts serial numbers to years or days.
Tutorial Tools

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Comment


Go Back   PC Help Forum - Free Computer Help, Windows, Hardware, Software and more! > The Important Stuff > Tutorials > General Application Tutorials




Tutorial Tools
Display Modes

Posting Rules
You may not post new tutorials
You may not post comments
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are On


All times are GMT +1. The time now is 09:32 AM.