Multi-Currency Income Statement || Financial Modeling || Radio/ Option button in Excel

[@wuraolaokuwobi9071]

Thank you very much. This video is very helpful.

[@oluwatosinomisakin7222]

Thank you so much for making this video and the other one on scenario analysis! I can't wait to see your other videos. My newly found excel superstar! Thank you, Bunmi!

[@YouExcelTutorials]

I'm glad you found them useful. Thanks for your kind feedback Tosin!

[@ezekielnkum1781]

Thank you. Very helpful. I would like to know how will you apply variable exchange rates with currency switch across different time series or time points?

[@sindhuns4]

if you edit the ExchangeRate naming to include the whole of exchange rate row, it works.

[@zeinabcole6808]

Thank you for this video. it was helpful. May i ask if you have a version for mac users because some of the steps are different. What is the manual instruction for f4.

[@samsonfamily]

This very useful, however, it doesn't allow for multiple currencies on the same page. So for example, in your input sheet, you show the price of sea salt and sugar both in USD dollars. But perhaps I source Sea Salt in USD and Sugar in CDN. How can I show that in two currencies, but at the bottom (price by currency) it will convert to whichever radio button I choose. Is that possible?

[@YouExcelTutorials]

Hi Jonathan. In this scenario, an easy way would be to show the CAD value of sugar in a separate cell, then convert the price to USD by dividing the CAD Value by 1.25. The price by currency will be linked to the converted USD amount, that way the radio button will work based on whichever currency you choose. I hope this helps

[@daveclark9411]

ᎮᏒᎧᎷᎧᏕᎷ ?