How To Use The IFERROR Function In Excel - The Easy Way!

[@TheOrganicChemistryTutor]

Final Exams and Video Playlists: www.video-tutor.net/

[@olvinmejiarivero9373]

Thanks a lot men, that actually helped me solve my homework!!!!!

[@chrisseydittus8574]

Thank you this really helped. It's hard to find exactly what is needed for our specific spreadsheets.

[@Pablo_Trader]

Thank You, You have been very helpful and provided a solution for the errors in my data.

[@SanisaI]

Great explanation.👍

[@ProKhata]

You can use the IFERROR function to trap and handle errors in a formula. IFERROR returns a value you specify if a formula evaluates to an error; otherwise, it returns the result of the formula If value or value_if_error is an empty cell, IFERROR treats it as an empty string value (""). If value is an array formula, IFERROR returns an array of results for each cell in the range specified in value. See the second example below.

[@sherlyjohn2995]

very good nicely explained

[@salnaud8898]

Thanks for your time to create this video (appreciate). My suggestion is to create you example sheet not in your video as it takes time and does not add any value. In this way the video become shorter, and the message will be delivered faster. Thanks

[@learner3481]

Thank you very much was searching for the same

[@cheekuu26]

Thanks

[@maryalarid6010]

Thank you

[@mdrakibulhasanmahmudcmamba5919]

Thanks dear

[@Mygoogleaccount-gr2qf]

Thanks alot

[@moodkn]

Great....Thanks...

[@biancardir]

Thank you.

[@patrik1789]

You diden´t even dividend the same column in Iferror?

[@83mmakki]

i was gonna say the same thing. he messed up

[@hinalshah2691]

Exactly

[@DiaborMagics]

Hm, I was using =isna because I got some N/A errors but of course that only returns True or False, which is not what I want. It seems like iferror is better then. There's probably no way to make isna return anything else than the boolean evaluation?

[@DCh-ks6ug]

sir what if i want to return it as the word null instead of error value 0 ?

[@teeenshi7271]

Use " " instead of 0

[@SaiymaBashir]

God bless you

[@miamited69]

What if subtract a blank cell and leaving the cell with the iferror blank?

[@jamespaul4618]

2:25 example syntax using if error and returning the desired output

[@drakepristash]

Freakin awesome!

[@irislekkerkerker8950]

When I'm typing values between the ''....'', I get the error ''There's a problem with this formula''. Do you know how to solve this?

[@7Earthsky]

Did you figure out this problem? I'm getting the same one.

[@brentsrx7]

Do you do everything?

[@sarfarazhussain8864]

Thnk u

[@teclasicbaldi]

what if instead of the error we have a wrong string like "9999". how we can make Excel avoiding that?

[@Jellevip]

doesn't work on my macbook

[@mariofernandes4063]

How about when you have same problem when you giving rank formula.

[@WowPlusWow]

Does anybody know what this guy looks like?

[@sandiyamonisha4181]

why lol

[@tgriff4231]

a goat

[@awsjm]

WHAT !!!!! lol

[@alibakhtiari6297]

I wonder if that's what he wants every one to think about..

[@teclasicbaldi]

i don't know but has a nice voice 😄

[@hamidmghazi]

[@ASHISHSHARMA-mt4nj]

=IF([@[task_type]="pickup",[@supplier_id],[customer_id]]) - why this is not working? can anyone help me pls.