Carry positions. Create positions for each currency, either $1 (long), $-1 (short), or 0 (flat). Do this

Fantastic news! We've Found the answer you've been seeking!

Question:

Carry positions. Create positions for each currency, either $1 (long), $-1 (short), or 0 (flat). Do this by going short the three currencies with the lowest interest rate, and long the three with the highest interest rate. (Hint: you can use the Excel function IF twice, one inside the other: = IF( cell <= 3 , -1 , IF(cell>=7,1,0)). What is the average position in New Zealand?