The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » advanced excel training - IF function

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

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

Training information:

advanced excel training - IF function

Resolved · Low Priority · Version Standard

ReplyThu 29 Mar 2007, 15:32Delegate Amanda said...

IF function

Why would I use an IF function?

For upcoming training course dates see: Pricing & availability

ReplyFri 30 Mar 2007, 09:48Trainer Tracy said...

RE: IF function

Hi Amanda,

Thank you for your question, you can use functions like the IF function to perform calculations based upon conditions. You can use the IF function to return one of two values based on whether a condition is true.

For example, IF(A1+B1>500, "Met target", "Under target")
so in this case depending on whether A1 + B1 is bigger than 500 will decide whether the return value is Met target or Under target.

Hope this helps

Tracy

Excel articles

· Using The Excel Forms Toolbar To Spruce Up A Workbook
· Creating Error Alerts In Excel Using Data Validation
· Microsoft Excel Courses Teach Advanced Macro Techniques
· Let Excel look after the pennies, and the pounds will take care of themselves
· How To Identify The Most Critical Data In A Large Excel Spreadsheet

Excel tip:

New Normal Worksheet

Do you want all your worksheets to confirm to a certain look? Then change the Defaults!!!
1. Press Shift+F11 to create a new worksheet
2. Press Ctrl+A to select (higlight) all cells, Press Ctrl+1, make any formatting changes then click OK.
3. Press F12 (Function 12 key) click in the Save As Type, drop down, then select Template (*.xlt)
4. Click in the Save in drop-down, then find the folder; c:_program files_microsoft office_office_start. (For the underscores shown use backslash)
Name your templete sheet.xlt, then press Enter.
Sheet.xlt is used when you insert a new worksheet (Shift+F11)

Note: These changes are permanent changes on your PC.

View all Excel hints and tips

Why isn't my web page updating when I have make changes in template.

» Forum post: TEMPLATE

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions