Fix Currency Conversion in Google Sheets
Budget: $10 – $30 AUD
I'm looking for someone to fix a Google Sheet where the total isn't calculating correctly due to currency exchange issues. The sheet currently sums all amounts in AUD, but it needs to first convert foreign currency amounts (USD, EUR, GBP, THB) to AUD and then sum everything.
Requirements:
- Correct the total calculation by adding currency conversion. Not manailly, it should use google exchange lookup to get daily rates. It should update frequently for accuracy.
- Use up-to-date exchange rates for accuracy.
- Ensure the sheet is easy to understand and maintain
Ideal skills and experience:
- Proficiency in Google Sheets
- Experience with currency conversion formulas
- Attention to detail
Requirements:
- Correct the total calculation by adding currency conversion. Not manailly, it should use google exchange lookup to get daily rates. It should update frequently for accuracy.
- Use up-to-date exchange rates for accuracy.
- Ensure the sheet is easy to understand and maintain
Ideal skills and experience:
- Proficiency in Google Sheets
- Experience with currency conversion formulas
- Attention to detail