Excel - If Function

After a while of using spreadsheets you get to a point where you need better control on how data is being presented to the end user. Quite often this requires you to make "interpretations" of the data to provide an outcome suitable to the business at hand. Well this is where (not always!) the IF function comes into play.

The purpose of the IF function is to allow you to control how data is displayed or derive a formula based on set values within the sheet. This video will explain how an if statement works and how you can control the results being returned. If functions are common place in spreadsheets so it is a key skill you will need to understand if your using spreadsheets day to day in your job.

Following this video we will focus on the dreaded "Nested If", this can be straight forward or ridiculouslycomplex! This will be covered on a subsequent Video and other better ways of performing evaluations on values...

Category:

Education

Tags:

• Excel
• Formula
• Formulas
• Function
• Functions
• If
• Microsoft
• Office
• Spreadsheet
• Spreadsheets

[PCTeachME]

@Karua003 Hi, that's great news! Glad I could help and thanks for the feedback!

[Electric888]

Thanks a lot for pointing out the autosum function + explanation!

[PCTeachME]

@Electric888 Thanks for the feedback. Let me know if you want anything else explained via video.

[Karua003]

Thanks for the help, I really didn't have a clue what to do in the start but now I know! :)

[GuardMasterTeam]

I have a list of performance numbers for salespeople and I want to grade them A,B,C,D,F. For example an "A" would be 70% and above, "B" 55% to 69%, and so on. I know basic "IF" functions but not this.

[1996Zi]

thnx a lot man. have an exam 2morrow but was clueless about this

[alikia41]

tnx man your the best today i had test and i had to learn that thank you