IF Function in the Formula Tool - Not pulling the correct column of data that it should be

[katos]

This is from the Select tool showing all of the data types. 

This is the formula.

But when I run it, it's giving me the Local amount instead of the USD amounts for account "2822"

Any ideas on what's happening or how to fix this issue?

[MilindG]

@katos  Cheers!