Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formulas

Formulas

ResolvedVersion Standard

Wed 20 Feb 2008, 16:01 Delegate Jonathan said...

Jonathan has attended:
Excel Intermediate course
Excel Advanced course

Formulas

What is the purpose of IF statements?

Sat 23 Feb 2008, 22:47 Trainer Cress said...

RE: Formulas

Say you have a list of data for a sales department. If the value of the sale was 1-15 then you want the value in the column to say 'Small Sale', value is 16-30 then 'medium sale', value is >31 then 'large sale' then this could be achieved by using an if statement. One example of many.

Excel tip:

Validating text entries

1. Select the range of cells.
2. From the Data menu, select Validation.
3. Select the Settings tab.
4. From the Allow dropdown list, select Custom.
5. In the Formula box, enter the following formula: