Knowledge speaks, but wisdom listens.- Jimi Hendrix
 News Tutorials Code Samples Blogs Forums

### Getting Started with Excel

Page: 2 of 4
(View All)

#### TYPES OF DATA:

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.

examples:

##### FUNCTIONS:

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

examples:

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 »

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

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

#### Tutorial Stats

21,558 Views
0 Rating of 5 ( Votes)

#### Tutorial Options

· Read more by this author

·