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(Currency@row = "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-

=IF(Currency@row = "KRW", [KRW to USD]@row), IF(Currency@row = "GBP" , [GBP to USD]@row)

can anyone help?!


Jasmine

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    You are on the right track. It is just a minor syntax issue. When nesting IF functions, you leave the first one open and start the second in the "else" portion of the first. Then you start the third in the "else" portion of the second, so on and so forth. Then you close them all at the end.


    =IF(this is true, do this, IF(that is true, do that))


    =IF(Currency@row = "KRW", [KRW to USD]@row, IF(Currency@row = "GBP" , [GBP to USD]@row))

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!