Left Quote    Knowledge speaks, but wisdom listens.
- Jimi Hendrix    
Right Quote
[login] | [Register]

Getting Started with Excel

by: bs0d
Page: 2 of 4
(View All)


We are discussing four types of data. Labels, Values, Formulas and Functions.

LABELS always begin with a letter (A-Z, a-z) and are used for headings, titles and text type of info.
VALUES are used to enter numbers. Values always begin with a digit (0-9).
FORMULAS are used to do a calculation and always begin with an equals sign. If you forget the equals sign, it will be entered as a label.



are built in routines designed to perform a specific task, and always begin with an ='s sign.


The IF function is used to test a condition to see if its true or false. One action is taken if the condition is true, and another if the condition is false.

examples using the IF FUNCTION...

Excel will test to see if A1 is greater or equal to 60. if A1 is greater than or equal to 60 then the word PASS will be placed in the cell where the function is being entered. If A1 is less than 60, the word FAIL is placed where the function is being entered.

Excel tests to see if A1 is greater than 100. If it is, the value of A1*10 will be placed in current cell, if A1 is less than 100, then the result of A1*5 is placed in the current cell.

Remember, if you want text to appear in the cell if the condition is true/false, the text must be enclosed in double quotes.

1  |  2  |  3  |  4  |  
Next »


  Subject: "nice" Date: Jan 06 2008 at 10:09 am    

very nice
You Must be logged in or a member to comment.

Tutorial Stats

Tutorial Stats

1 Total Comments
0 Rating of 5 ( Votes)


Tutorial Options

· Login to Rate This Article
· Login to Post a Comment
· Read more by this author
Digg This Article! Bookmark This Article Reddit: Bookmark This Article BlinkList: Blink This Article! YahooMyWeb BlogMarks: Add This Mark! Furl: Save This Article Spurl: Mark This Article



· Databases and Access
Your Article Here

"" Copyright © 2002-2019; All rights lefted, all lefts righted.
Privacy Policy  |  Internet Rank