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.

0 votes

Loading... 2,637 views

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

1. Hemant Giri says:

   29/01/2014 at 11:21 pm

   u teach so nice and easy way thank u so much 

   Reply
2. Ivan Carrillo says:

   29/01/2014 at 11:56 pm

   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? 

   Reply
3. Don Flood says:

   30/01/2014 at 12:34 am

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

   Reply
4. Snowyscar says:

   30/01/2014 at 12:58 am

   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.

   Reply
5. robertbobm says:

   30/01/2014 at 1:30 am

   =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”.

   Reply
6. evilpisces says:

   30/01/2014 at 2:20 am

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

   Reply
7. robertbobm says:

   30/01/2014 at 2:37 am

   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:

   Reply