Excel Tutorial 7 of 15 – Using the IF Formula

Excel Tutorial 7 of 15 - Using the IF Formula

Microsoft Excel Tutorial 7 of 15. How to use the IF formula in Excel. The IF formula in Microsoft Excel can be used to see if a cell meets certain criteria, …

Don’t forget to check out our other video tutorials or share this video with a friend.

1 Star2 Stars3 Stars4 Stars5 Stars 0 votes
Loading... 1,768 views





7 responses to “Excel Tutorial 7 of 15 – Using the IF Formula”

  1. Hemant Giri says:

    u teach so nice and easy way thank u so much 

  2. Ivan Carrillo says:

    Hello, can you please help me with something? What function or formatting
    do I need if I have a salesforce list that I want to automatically update
    its order based on sales amount also in excel? 

  3. Don Flood says:

    Great tutorial; will use with my students. Thank you.

  4. Snowyscar says:

    Great tutorials! What you should do is post a link to an uploaded document
    with the same characteristics as the one you used in your videos, and let
    people try to do what you did. People learn best when combined with
    practice.

  5. robertbobm says:

    =IF(A1=1,5000,IF(A1=2,4000,IF(­A1=3,3000,”no match”))) This says: if a1 =
    1, then put 5000, if a1 = 2 then put 4000, if a1 = 3 then put 3000,
    otherwise put “no match”.

  6. evilpisces says:

    Thank you, all these tutorials are very good, clear and helpful.

  7. robertbobm says:

    Thanks! Yes, that’s certainly possible. There are a couple of different
    ways to accomplish this. One way would be what you’re referring to, which
    is called a “nested IF” statement, where you put an IF statement inside
    another IF statement. Youtube doesn’t let me use “greater than” symbols in
    comments here, so I can’t use your example, but here’s a similar example:

Leave a Reply

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