Windows 7 Support
Become a Fan of PCHF on Facebook!
User Reviews - Add Yours!
The PCHF Lounge
Go Back   PC Help Forum » Tutorials » General Application Tutorials
Register for a Free Account

General Application Tutorials - How to use formulae 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 ...

Advertisement
Advertisement

Reply
Free PC Performance Scan
Old 08-01-2005   #1
Trusted Security Analyst
 
merlin's Avatar
 
Join Date: Jul 2005
Location: NW Indiana
Posts: 2,891
PC Experience: Comnputers Fear Me..
Default How to use formulae 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, you can click the fx button on the formula bar to list all the functions available.

Functions are generally named relative to what they do, are in all caps, and follow this format:
=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. The function example, =SUM(A2:A8), adds cells A2-A8 together.

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.

Last edited by upgrader; 05-05-2009 at 07:33 PM.
merlin is offline   Reply With Quote
Old 3 Weeks Ago   #2
Bronze Member
 
Join Date: Feb 2010
Posts: 20
PC Experience: Some Experience
Default Re: How to use formulae in Excel

Hey All,

Oh great one.. thanks for Sharing it with us. This can be very useful for all of us.

Thanks,
James
artm is offline   Reply With Quote

Reply

Bookmarks

Tags
excel, formulae, formulas, information, Information:, [Information]
Similar discussions...
Thread Thread Starter Forum Replies Last Post
Solved: Excel Wierdness miken707 Office Software 2 10-13-2008 10:17 PM
Pending: excel mrbloby Office Software 1 06-24-2008 02:17 PM
Excel dakita Office Software 1 12-06-2006 10:24 PM
Formatting in Excel Connor707 Office Software 2 07-27-2006 04:13 AM

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB 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. The time now is 05:22 PM.
Powered by vBulletin
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.3.2