Excel - IFERROR function

Поделиться
HTML-код
  • Опубликовано: 24 июн 2012
  • Many more great Excel tutorials linked below:
    • Microsoft Excel Tutorials
    Be sure to watch my other Excel tutorial videos on my channel, including more advanced techniques
    and many useful and practical ones. Be sure to Subscribe and Comment.

Комментарии • 71

  • @venumadhavdesai3253
    @venumadhavdesai3253 5 лет назад

    i checked so many places , but did not understand this formula, now it's 100% clear sir, Thank you

  • @sayedsaid8615
    @sayedsaid8615 11 лет назад

    i swear to God ,,, you are the man .. you've solved the big error i got in Excel in my work

  • @kuhlmikeb
    @kuhlmikeb 10 лет назад +1

    Very easy to understand compared to my computer class book examples. So many concepts to learn in this excell class. Your video my save my but in the exam tomorrow!

  • @phoebele8187
    @phoebele8187 2 года назад

    Such a great video. I got it easily instead of reading a lot of instructed files.

  • @kalynreburiano7323
    @kalynreburiano7323 4 года назад +1

    Thanks for making it super easy to understand.

  • @emilysable6469
    @emilysable6469 10 лет назад +5

    Thanks for making it super clear, it really helped

  • @aler13CR
    @aler13CR 11 лет назад +1

    Exactly what I needed!! Thanks :D

  • @romyghosh6765
    @romyghosh6765 9 лет назад +4

    Well explained

  • @billwood1245
    @billwood1245 7 лет назад +1

    GENIUS!!! Thank you!

  • @MrKunal995
    @MrKunal995 4 года назад

    Thank you so much! Such a useful function, I was completely oblivious about!!!

  • @vikrammanchala8672
    @vikrammanchala8672 11 лет назад +1

    Thank you, this is helpful for me.

  • @rahulkishore3340
    @rahulkishore3340 6 лет назад

    Simple and to the point, just what I like.

  • @lilomm
    @lilomm 12 лет назад +1

    Thanks! This was very helpful for me as a beginner in Excel. :)

  • @manojtanwar2580
    @manojtanwar2580 2 года назад

    Very simple & easy to understand explanation
    .keep it up bro

  • @akdbgl
    @akdbgl 2 года назад

    Explained nicely, really helpful.Thanks,

  • @violamarufu2748
    @violamarufu2748 9 лет назад +1

    Thank you so much, you helped correct something for my boss

  • @mariar8025
    @mariar8025 5 лет назад +1

    Thanks for the explanation. I can use this when I get #n/a.

  • @incub8
    @incub8 9 лет назад +2

    Hi. Nice video. What program are you using that allows you to markup your live Excel worksheet with the red pen? I need this function in my lesson demos. Thanks!

  • @davidwalsh1888
    @davidwalsh1888 5 лет назад

    Clear and concise. Thanks.

  • @rdjalayer
    @rdjalayer  11 лет назад +2

    glad I could help sayed, come back to the channel soon

  • @charlenenicoll708
    @charlenenicoll708 9 лет назад +1

    Excellent video clearly explained

  • @vyvy302
    @vyvy302 9 лет назад

    thankyou very much ^^ you helped me with my homework ^^

  • @reneehin23
    @reneehin23 8 лет назад +2

    Hello!Great video! do you know if there is a way to hide the rows that have the error is there a command that says something like "If error hide entire row?"

  • @NaenaeRudklao
    @NaenaeRudklao 8 лет назад

    great help! thanks!!

  • @jdenzen
    @jdenzen 10 лет назад

    great video with clear explanation. thanks..

  • @KatEyze1015
    @KatEyze1015 6 лет назад

    Exactly what I need!

  • @kylejansen8448
    @kylejansen8448 8 лет назад

    Thanks dude! great video

  • @haydersami2643
    @haydersami2643 4 года назад

    Thank you , very good teaching way

  • @samuelsipho9039
    @samuelsipho9039 3 года назад

    Thank you so much.

  • @skippyflatrock
    @skippyflatrock 8 лет назад +3

    Thank you so much for makeing this video. It helped me so much, now I can continue makeing my Data base for merit traking with out haveing to present errors in all of the cells that do not have info. HELP>>>> One question though how do I make a value ="" if the out put is 0?

  • @sayrothelmanonsol6304
    @sayrothelmanonsol6304 5 лет назад

    Thank you for this. 😊

  • @munjaalraval
    @munjaalraval 3 года назад

    Thanks.. it was helpful

  • @dharitrisahoo3361
    @dharitrisahoo3361 6 лет назад

    Well explained 🖒

  • @chefcriz5688
    @chefcriz5688 3 года назад

    thank you so much for this really helpful tips..

  • @rrplaystation8056
    @rrplaystation8056 7 лет назад

    awesome. thank you

  • @sumangoud8215
    @sumangoud8215 11 лет назад

    Thank you.. it did help me

  • @NjabuloHadebe
    @NjabuloHadebe 3 года назад

    Beautiful Thank you!!!

  • @patrickly8547
    @patrickly8547 3 года назад

    Thanks!

  • @donaldjr224
    @donaldjr224 2 года назад

    Thank you so much...

  • @TheJanagan
    @TheJanagan 11 лет назад

    Thanks.......... very nice. I am jana from Sri lanka

  • @MAAAX2211
    @MAAAX2211 4 года назад

    very informative video
    thanks

  • @iamjochris
    @iamjochris 6 лет назад

    Thanks Bro!

  • @raja.mubbasshir9072
    @raja.mubbasshir9072 4 года назад

    Thank you very much sir!

  • @MrRakesh4u
    @MrRakesh4u 10 лет назад

    Thanks for sharing..

  • @maggiesourcinginchina3556
    @maggiesourcinginchina3556 8 лет назад

    very good, thanks

  • @cecesuhaemi1837
    @cecesuhaemi1837 7 лет назад

    great help.

  • @iftikharahmad015
    @iftikharahmad015 8 лет назад

    thank you

  • @manpreetkaur040587
    @manpreetkaur040587 9 лет назад

    Oh thank you sir.

  • @naqashsajid7985
    @naqashsajid7985 2 года назад

    Thanks man

  • @frankdiazlopez5549
    @frankdiazlopez5549 4 года назад

    Easy way to explain it thanks

  • @mamunabdullahywna
    @mamunabdullahywna 8 лет назад

    Great !

  • @TaniaAhuja
    @TaniaAhuja 5 лет назад

    that was quite helpful

  • @investingclub5897
    @investingclub5897 4 года назад

    thanks!

  • @kendethar
    @kendethar 3 года назад

    Thanks

  • @shineheungchannel3181
    @shineheungchannel3181 2 года назад

    thx u so much

  • @joydeepsingh9113
    @joydeepsingh9113 9 лет назад

    very nice .. thanks ... :)

  • @MP-dx9wt
    @MP-dx9wt 5 лет назад +2

    bro just what I wanted...

  • @activegrowth166
    @activegrowth166 3 года назад

    Great

  • @manojkumarexcel
    @manojkumarexcel 4 года назад

    V goodn

  • @rdjalayer
    @rdjalayer  12 лет назад

    glad I could help

  • @ahmedbilalafzal8093
    @ahmedbilalafzal8093 5 лет назад

    1.5x

  • @SteS
    @SteS 8 лет назад

    What happens if the error is '#############'

    • @whitneypennington2429
      @whitneypennington2429 8 лет назад

      +Stephen S You need to make your cell bigger so the whole number can fit in the cell. :)

    • @SteS
      @SteS 8 лет назад

      +Whitney Pennington :] Thanks, yes I done that when I had the problem. It's been a while and I forget what it was. :[ I solved the problem anyway. There's certain things in excel that are not errors and some that are. This was one of them.

    • @skippyflatrock
      @skippyflatrock 8 лет назад

      +Stephen S, All you need to do is hover over the deviding line of the 2 colloms then duble click. then your collom with auto resize to the side you need so that you can read the Cell.
      Example: say you are getting that error in Cell H3. Hover between the collom names(H & G) then your cursor should look like a Vertical line with arrows comeing out of it horizontaly. Then left click 2 times then your cell will auto size to the shape it needs, or you can manualy resize by holding down the left click then dragging it the the right.

    • @SteS
      @SteS 8 лет назад

      +skippy flatrock thanks, I'm aware of that also. This was not the cause. I cannot remember how I got round it but thanks for the help. :)

  • @forhereortogo5015
    @forhereortogo5015 4 года назад

    Your a G

  • @AnfalBalagamwala
    @AnfalBalagamwala 8 лет назад

    Thanks!

  • @mdabdussalam6849
    @mdabdussalam6849 6 лет назад

    Thanks