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

the if function

ResolvedVersion 2007

Kelly has attended:
Excel Intermediate course

The IF Function

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

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.

Excel tip:

Hiding and unhiding columns using the keyboard

CTRL + 0 hides your columns and CTRL + SHIFT + ) unhides them although you would need to highlight the column letters either side as per normal

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.