Excel 2007 Nested IF Statement

I need help your help. I have 3 columns as shown in the sample image.

I would like a formula for a nested IF statement in order to calculate the amount in local currency [Column C] by different rates for each currency Click For Sample