Multiple IF function pull from multiple cells
I am working on a spend tracker and i am having trouble pulling currency conversions from other cells in the row.
I need the 'committed amount in USD' to pull from the correct currency conversion cell depending on the currency selected.
current formula i have that works with pulling from just one cell is -
=IF([email protected] = "KRW", [KRW to USD]@row)
how can i add to this to make it pull from other cells if the currency is different?
I have been trying this and it isnt working-
can anyone help?!