Excel IF function formula – 12 Examples

25 Responses to “Excel IF function formula – 12 Examples”

1. ExcelIsFun on: 8 March 2010 at 10:20 pm

   Try this video:

   Excel Magic Trick #71: Excel Will Talk To You
2. nicoyanicoya on: 8 March 2010 at 11:06 pm

   learning a trick a week!
   how did you get your excel to “say” the numbers..i can hear it in the background!
3. ExcelIsFun on: 8 March 2010 at 11:32 pm

   Now that’s probably an Excel first!
4. bbdarthchris007 on: 8 March 2010 at 11:51 pm

   I made an excel “program” to help me punish my kid fairly. I love it you can do almost anything with excel
5. hasina21 on: 8 March 2010 at 11:52 pm

   Thanks for the replay anyway appreciate it.
6. ExcelIsFun on: 8 March 2010 at 11:54 pm

   I do not know how to do that. You should post your question to the Mr Excel Message Board (THE smarest Excelers around ahng out at this site):

   mrexcel[dot]com/forum
7. hasina21 on: 9 March 2010 at 12:14 am

   Hi, I am looking to validate UK Postal Code using IF formula in MS Excel, can you be any help!!! The postal code is should be in the following format:

   AN NAA
   ANN NAA
   AAN NAA
   ANA NAA
   AANA NAA
   AANN NAA

   When A is alphabet and N is number. If the condition is incorrect then highlight that particular cell that contains the incorrect postcode.
   Many thanks in advance.
8. ExcelIsFun on: 9 March 2010 at 12:33 am

   Search for and watch this video tile:

   Search & Find Excel Videos, Playlists, Download Workbooks – excelisfun
9. kohtnet on: 9 March 2010 at 12:36 am

   Excewllent just saw your viedeo. I want to learn excel and want to be perfect but I am just a biggner. How long it takes to be perfect in excel. How can i download your download the workbooks. I hope i can learn something for your watcing video’s. I write down what you says in videos and it’s takes a long time. If you a note which you have a videos’ might be learn fast. Keep on posting. Thank
10. ExcelIsFun on: 9 March 2010 at 1:25 am

    I will!!
11. nicoyanicoya on: 9 March 2010 at 1:26 am

    love that u are doing 2007 now !!!
    Keep it up professor !!!
12. TheDanCas on: 9 March 2010 at 1:57 am

    there’s two L’s in his name…
13. ExcelIsFun on: 9 March 2010 at 2:30 am

    You are welcome! I am happy to hear that you download the workbooks also, many people don’t, and thus don’t get the full effect!!
14. romanticgirl888 on: 9 March 2010 at 2:41 am

    Dear Mr. ExceIsFun,

    You rock! I learned so much for your videos and workbook. Thanks!!!

    Jen
15. ExcelIsFun on: 9 March 2010 at 2:58 am

    If you look down the IF function playlist:
    1) You will see the videos about “nesting” IF functions, which will be good for your question about how to have multiple IFs in one formula
    2) You will see one for “Medain IF”, this one will show how to use IF in an array.
16. Mynotoar on: 9 March 2010 at 3:11 am

    That was especially interesting, the part on using a drop-down list to be able to decide what specifically to calculate. I’m gonna trundle through this playlist in the hope that I find how to use IF in an array / multiple IFs lol.
17. ExcelIsFun on: 9 March 2010 at 4:11 am

    I don’t understand your question. Can you state your question differently?
18. poi9090 on: 9 March 2010 at 4:45 am

    here displayed #name? =/
19. ExcelIsFun on: 9 March 2010 at 5:29 am

    Dear BerPC96,

    I don’t know who Video Professor is. But I have over 800 Excel how to videos. You may be interested in the Excel Basics Series and the Highline Excel Class series. watch this video title to see how to get to these videos and how to download the free book and Excel workbboks:

    Search For Excel Videos Download Excel Files excelisfun

    –excelisfun
20. BerPC96 on: 9 March 2010 at 5:34 am

    Taking this in college right now what are some out of class materials that you can give me that would help supplement my learning experience……does video professor warrant any investigation for good material????
    Thanks!
21. ExcelIsFun on: 9 March 2010 at 5:38 am

    Dear RJ8976,

    I have a Video Playlist that shows many ways to do this:

    Various Excel Grade Book Examples

    If you can’t find it, search for and watch this video that will show you how to use the excelisfun channel including finding Playlists:

    Search For Excel Videos Download Excel Files excelisfun

    –excelisfun
22. RJ8976 on: 9 March 2010 at 6:27 am

    I am just learning to use excel and was wondering what the if function would look like when trying to determine which students Passed/Failed (i.e. got a mark of 50% or >). I tried a few different things but I cant get it to work…

    thanks!
23. ExcelIsFun on: 9 March 2010 at 7:00 am

    Dear huyenng,

    Try this video:

    Excel Magic Trick #5: Data Validation & VLOOKUP

    –excelisfun
24. huyenng on: 9 March 2010 at 7:24 am

    EXCELlent!
    I have a question: how to make the DROPDOWN, like the one you have in your example.
25. ExcelIsFun on: 9 March 2010 at 7:48 am

    Dear pwnions08 ,

    You are welcome!

    –excelisfun