FinanceTier 015 minbeginner

Currency Conversion Basics

Convert a column of mixed-currency transactions to ZAR without double-converting the ones already in rand.

What you will learn

• Write a formula that converts only foreign-currency amounts, leaving ZAR amounts untouched
• Explain why summing a mixed-currency column directly produces a meaningless total
• Recognise which column in a ledger is the true reporting currency

Excel skills

IF, basic arithmetic · Basic Formulas

The task

This transaction list mixes ZAR and USD amounts in one column. In D2, write a formula that converts USD amounts to ZAR at 18.42, while leaving ZAR amounts exactly as they are.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free