Basic Excel Function - How to use IFERROR Function in Excel


For this tutorial, I have created an Investment Portfolio with some popular Stocks and Cryptocurrencies. These include Tesla, Facebook, Alibaba, Amazon, Bitcoin, Ethereum, Dogecoin and AMC (Wall street bet’s favourites). To make this tutorial enjoyable, I had added some internet slag: “To the moon”, “HODL” and “Diamond Hands”.


We will also show you how to convert your IFERROR function in an API at the end of the video.


Download: AlchemyJ FREE Community Edition: https://www.alchemyj.io/download


Learn More: How to setup AlchemyJ: https://www.youtube.com/watch?v=eTyYTf1sw9k&feature=youtu.be&ab_channel=AlchemyJ​​​


How AlchemyJ works: https://www.youtube.com/watch?v=bAQHo8I1xuQ&ab_channel=AlchemyJ


Let's connect: LinkedIn: https://www.linkedin.com/company/alchemyj/


Article

How to use the IFERROR Function in Excel? For this tutorial, I have created an Investment Portfolio with some popular Stocks and Cryptocurrencies. These include Tesla, Facebook, Alibaba, Amazon, Bitcoin, Ethereum, Dogecoin and AMC (Wall street bet’s favourites). To make this tutorial enjoyable, I had added some internet slag: “To the moon”, “HODL” and “Diamond Hands”. Without further ado, let us get started.


How to use IFERROR Function

First, we will find the average cost for our stocks and cryptocurrencies. Select Cell E7, type in the equal, select on Cell D7. Hit on forward slash and select on Cell C7. Hit return, and you will get $80, the average cost per stock for apple.


Now, let us find the average cost per stock for the other investments. For this, we will be using auto-fill. Move your cursor to the lower right of Cell E7. Once your cursor turns to a plus sign. Double click on it. You will get all your average cost per stocks.


You will notice that the average cost for Gamestop, Bitcoin and Dogecoin is “value”. This is because we wrote “To the Moon”, “Diamond Hands”, and “HODL” instead of a numerical value. Excel would reflect a DIV / 0 error message when a number is divided 0. We did not invest any money in AMC, and we possess 0 stock. Hence, DIV / 0 was reflected on our excel sheet. The wording for Value and DIV / 0 looks less professional on our Investment Portfolio. Let us change the wording to “Please input invested amount”.


Select Cell E7, type in the equal IFERROR, open parentheses. Select Cell D6, hit on forward slash and select Cell C7. Type in a comma, open quote. Type in “Please input invested amount”. Close quote and parentheses and hit return.

Lastly, let's fill the list with the same formula. Move your cursor to the lower right of Cell E7 and double click on it. Instead of getting Value and Div / 0. we will get "Please input invested amount". Let's test the IFERROR. I will change the wording to a numerical number. Okay, it works out perfectly.


Intermission

There you have it, the IFERROR function for Excel. If you have any excel formula you want us to teach, let us know in the comment section below. Don't forget to subscribe, hit the bell button and turn on the notification to have more free excel function tutorial. But, before you go, we have a bonus clip for you. I will be turning this Excel spreadsheet into an API. Stay tuned to see how the magic works.


Convert IFERROR function into Application Programming Interface (API)

I will be using AlchemyJ Studio Excel Add-in to turn this IFERROR Function Excel into an API. To do this, I will need AlchemyJ Excel installed and with a pre-set of rules. I will select the AlchemyJ ribbon, select Generate API and click on Generate API. The file is now converting. Okay, your API is ready.


I will now launch this openAPI which AlchemyJ generates, and try using the VLOOKUP Function on it. I will expand this tab and select try it out. I will input Bitcoin, 1 coin and type in “To the Moon”. We got an IFERROR of “Please input invested amount”. Alright, now we will input “1000”. Will we get an error again? Nope, everything works out perfectly.


Closing

AlchemyJ Studio Excel Add-in turns your Excel business model into API. This way, you can integrate your Excel model into other applications. You can download AlchemyJ Studio Excel Add-in for free at alchemyj.io. And once again, thank you for watching. So which Excel function you wish to be converted into an API? Let us know in the comment section below. Lastly, don't forget to subscribe, hit the bell button and turn on the notification. See you soon.


50 views0 comments