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
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.
Final Exams and Video Playlists: www.video-tutor.net/
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
Thank you this really helped. It's hard to find exactly what is needed for our specific spreadsheets.
Thank You,
You have been very helpful and provided a solution for the errors in my data.
Thank you very much was searching for the same
Thanks a lot men, that actually helped me solve my homework!!!!!
very good nicely explained
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.
Great explanation.👍
Great....Thanks...
Thanks alot
Thank you.
Thanks dear
what if instead of the error we have a wrong string like "9999". how we can make Excel avoiding that?
Thanks
Freakin awesome!
You diden´t even dividend the same column in Iferror?
i was gonna say the same thing. he messed up
Exactly
What if subtract a blank cell and leaving the cell with the iferror blank?
God bless you
Thnk u
2:25 example syntax using if error and returning the desired output
How about when you have same problem when you giving rank formula.
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?
Did you figure out this problem? I'm getting the same one.
doesn't work on my macbook
Does anybody know what this guy looks like?
why lol
a goat
WHAT !!!!! lol
I wonder if that's what he wants every one to think about..
i don't know but has a nice voice 😄
=IF([@[task_type]="pickup",[@supplier_id],[customer_id]]) - why this is not working? can anyone help me pls.