Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Formulas

Resolved · Low Priority · Version Standard

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

Jonathan has attended:
Excel Intermediate course
Excel Advanced course

Formulas

What is the purpose of IF statements?

For upcoming training course dates see: Pricing & availability

Reply Sat 23 Feb 2008, 22:47Trainer 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 articles

· How Teachers Are Using Microsoft Excel To Enhance Learning in the Classroom
· How Getting Together Is Now Even Easier With Excel
· Excel 2010 A Glance Into The Future
· Let Excel look after the pennies, and the pounds will take care of themselves
· Tracking In Excel 2003

Please browse our web site to find out more about
best training excel vba and other Microsoft training courses.

Excel tip:

Autofit column width – Excel (all versions)

a. Highlight the column or columns you wish to alter the width of. You do this by clicking on the grey button at the top of the column showing the column letter. Click and drag on these letters to select more than one column.
b. Double click the dividing line between the columns. This dividing line is the break between the columns on the column headers (grey buttons showing the column letter at the top of each column). When you hover your mouse over one of these dividing lines the point will change and show an arrow pulling a line in two directions. When you have this mouse pointer you should double click to get Excel to automatically set the column width to fit the contents of the column (autofit)

View all Excel hints and tips