Advanced Excel – Using the IF Function in Excel to Program Your Spreadsheets




About this tutorial:

Video duration: 5:43
Learn how to use the IF function in Excel to “program” your spreadsheets to show you certain data. You can create If ________ then _______ statements that can produce powerful results in Excel. #excel #exceltutorial

***Consider supporting Technology for Teachers and Students on Patreon***:

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

26 thoughts on “Advanced Excel – Using the IF Function in Excel to Program Your Spreadsheets

    sarah williams

    (October 23, 2018 - 7:44 pm)

    Thank you

    Saie corp

    (October 23, 2018 - 7:44 pm)

    Very nice, you teach very well.

    eight Leaft

    (October 23, 2018 - 7:44 pm)

    🚈🚂看美女😘大尺度私密写真视频➕微信hot5383✈️✈️发海地共和国奋斗仿佛f f g g

    veeranjaneyulu bandi

    (October 23, 2018 - 7:44 pm)

    Good explanation.

    Rome Davidson

    (October 23, 2018 - 7:44 pm)

    incredible! make it so simple .. thank you very much!

    erin davitt

    (October 23, 2018 - 7:44 pm)

    Great tutorial…but why the space before the quotes? Wouldn’t it work without the space?

    Ayoola Nana

    (October 23, 2018 - 7:44 pm)

    I need some help. I have d numbers in 3 different cells A, B and C on 2 different rows. I want to know the number of possible sums i can get. So for instance cell A1 is 3 and cellA2 is 4 i know that is 7 but if cellA1 is not 3 i want it to sum cellB1 and A2 and also the option to sum cell C1 and A2 and so on till it sums cell C1 and C2.

    Kees Mulder

    (October 23, 2018 - 7:44 pm)

    If I type the exact same formula as you do, I get an error. Do you perhaps have any idea why this is?

    MD.Hossain Al Mamun

    (October 23, 2018 - 7:44 pm)

    What if someone gets 69?what is shown here pass or fail or it's skipped.

    Jorge Colin

    (October 23, 2018 - 7:44 pm)

    Loved it

    Jose Mari belmonte

    (October 23, 2018 - 7:44 pm)

    For example: test 1= 96, test 2=70, test 3= did not take the exam.
    Above 85 should show passed and below 85 and did not take the exam show failed. What kind of formula can i use??

    kskdtr

    (October 23, 2018 - 7:44 pm)

    i got stuck with the IF formula…. how can i write the formula so that if the source cell is blank (your C), even the target (your D) is blank, otherwise it shows the time ofthe entry?

    Michael Lawn

    (October 23, 2018 - 7:44 pm)

    This is his real students and their names. Time to sue 😀

    Chuy Ponce

    (October 23, 2018 - 7:44 pm)

    Your videos are so easy to follow. I’ve been learning a lot from you. Thank you!

    Gazi Arif Mahmud

    (October 23, 2018 - 7:44 pm)

    69 means fail!!!?? Brutal teacher.

    DooDooMan

    (October 23, 2018 - 7:44 pm)

    What a great Tutorial ??

    Guest 2

    (October 23, 2018 - 7:44 pm)

    "I need to type it all over again…" :D:D

    Jonathan Hooker

    (October 23, 2018 - 7:44 pm)

    ummmm it's still programming, It's programming in the basic language, not exactly the one you learned, and maybe a little more higher level and visual. Still, I appreciate the video.

    Eric Erickson

    (October 23, 2018 - 7:44 pm)

    You didn’t explain one of the most important parts of the “IF”, what purpose does the space serve when preceding “ “? This normally isn’t used. It’s imperative that your learners have this information.

    jaspreet Kaur kohli

    (October 23, 2018 - 7:44 pm)

    Nice video unique study material….

    Ryan Calica

    (October 23, 2018 - 7:44 pm)

    Thank you very much. Your tutorials really helps me. 😆

    Arjay Repoyla

    (October 23, 2018 - 7:44 pm)

    Hi, i would like to ask for help on my formula. this is an example of my tabulation. Lets say I used column A1:A6.
    A1= today()
    A2= 25-jun-18
    A3= 2-jul-18
    A4= 9-jul-18
    A5= 16-jul-18
    A6= 23-jul-18
    Suppose i will be using A7 to write my formula. I have three schedules to rotate every week; 6am, 2pm, 10pm and i wrote it this way but didn't work why?:
    =if(A1>=A2,"6AM",IF(A1>=A3,"2PM",IF(A1>=A4,"10PM","")))

    Teodoro Allen

    (October 23, 2018 - 7:44 pm)

    thank you x10000!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

    ECxPassion

    (October 23, 2018 - 7:44 pm)

    Gore Jim?

    Md.Shariful Islam

    (October 23, 2018 - 7:44 pm)

    Thanks for sharing for such kind of video.

    Eric Erickson

    (October 23, 2018 - 7:44 pm)

    Probably important that you let your viewers know why the space is needed in the IF formula. This could lead to a lot of problems for beginners.

Leave a Reply

Your email address will not be published. Required fields are marked *