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.
i checked so many places , but did not understand this formula, now it's 100% clear sir, Thank you
i swear to God ,,, you are the man .. you've solved the big error i got in Excel in my work
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!
Such a great video. I got it easily instead of reading a lot of instructed files.
Thanks for making it super easy to understand.
Thanks for making it super clear, it really helped
Nice
Exactly what I needed!! Thanks :D
Well explained
GENIUS!!! Thank you!
Thank you so much! Such a useful function, I was completely oblivious about!!!
Thank you, this is helpful for me.
Simple and to the point, just what I like.
Thanks! This was very helpful for me as a beginner in Excel. :)
Very simple & easy to understand explanation
.keep it up bro
Explained nicely, really helpful.Thanks,
Thank you so much, you helped correct something for my boss
Thanks for the explanation. I can use this when I get #n/a.
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!
Clear and concise. Thanks.
glad I could help sayed, come back to the channel soon
Excellent video clearly explained
thankyou very much ^^ you helped me with my homework ^^
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?"
great help! thanks!!
great video with clear explanation. thanks..
Exactly what I need!
Thanks dude! great video
Thank you , very good teaching way
Thank you so much.
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?
Thank you for this. 😊
Thanks.. it was helpful
Well explained 🖒
thank you so much for this really helpful tips..
awesome. thank you
Thank you.. it did help me
Beautiful Thank you!!!
Thanks!
Thank you so much...
Thanks.......... very nice. I am jana from Sri lanka
very informative video
thanks
Thanks Bro!
Thank you very much sir!
Thanks for sharing..
very good, thanks
great help.
thank you
Oh thank you sir.
Thanks man
Easy way to explain it thanks
Great !
that was quite helpful
thanks!
Thanks
thx u so much
very nice .. thanks ... :)
bro just what I wanted...
Great
V goodn
glad I could help
1.5x
What happens if the error is '#############'
+Stephen S You need to make your cell bigger so the whole number can fit in the cell. :)
+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.
+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.
+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. :)
Your a G
Thanks!
Thanks