Nested IF/Vlookup formula to convert currency based on date and subtract two columns

Hi Everyone, I hope someone can help me.

Basically, I have three sheets, and what I would like to do is to display a calculated field in sheet 1 using (Total bets – Total wins) from sheet two. However, at the same, I want to convert the currencies from dollars to Euros, using exchange rates in the Exchange rate sheet.


Sheet 1
Based on the date, I need cell G5 to display the value of “Actors- Actresses” from sheet 2 . At the same time, I want the currency to convert using the exchange rates sheet. So if the currency in Cell B2 is "EUR", then I want the conversion to take place. If not, then I want only the value of "Actors- Actresses "I am assuming I need a nested IF formula, but I am unsure of the combination.

I have attached the spreadsheet for your reference. Thanks in advance.