the if function
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » The IF Function

The IF Function

resolvedResolved · Medium Priority · Version 2007

replyReply Thu 6 Aug 2009, 16:11Delegate Kelly said...

Kelly has attended:
Excel Intermediate course

The IF Function

Did not fully understand how this function worked. Would like further information.

For upcoming training course dates see: Pricing & availability

replyReply Fri 7 Aug 2009, 10:07Trainer Amanda said...

RE: The IF Function

Hello Kelly

Thank you for your question and welcome to the forum.

The IF function can be a bit tricky to understand to start off with. I've included a link below to a short video tutorial on the internet, with a slightly different example to the one we looked at on the course yesterday - you will need have sound on the computer in order to hear the guy in the tutorial explaining how the function works:

http://video.about.com/spreadsheets/IF-Function-in-Excel.htm

Also there are lots of tutorials on YouTube, if you search for excel if function or excel if statements.

I hope this helps.

Kind regards
Amanda

Thu 13 Aug 2009: Automatically marked as resolved.

 

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

Excel tip:

Display developer tab - Excel 2010

a. In Excel, click on the File tab
b. Select Options from left hand side
c. Choose the Customize Ribbon section
d. Click the box next to Developer in the list of tabs on the right hand side of the dialog box. When ticked the Developer tab will be visible.
e. Click OK to apply your changes

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard