Multiple IF Statements for Currency

Hi all,

I am trying to create a multiple IF statement for a calculation of budgets and I can’t seem to get it to work.

I am trying to have all my amounts in Euro and I am sometimes having amounts in other currencies and I’d like to calculate the amount in EUR. I can get it to work for a simple IF statement, but not for multiple. Also tried the SWITCH function but it didn’t work either.

The formula would have to look something like this.

IF({Currency}=“RON”, DIVIDE({Amount},4.93), IF{Currency}=“USD”, DIVIDE(Amount},0.95), IF IF{Currency}=“EUR”, DIVIDE(Amount},1)

Any help would be greatly appreciated.

Thank you,

Hi @DominicROCA
Happy New Year and welcome to the community
Your formula is close, but you need to have the closure of the nested if statements at the end
Screenshot 2023-01-03 at 09.33.59

Screenshot 2023-01-03 at 09.34.04

Hope the above give you what you need
Let me know if you need anything in addition
Many thanks Dan

@DanIngham-IOI this worked, thank you so much!

Hi @DominicROCA
No problem at all
Happy to help

If you wanted to round the figure and add the option to show select currency if nothing is selected
Then you can use the below
Note changing the 1 at the end of each if statement dipicts the number of decimal spaces, ie 0 will round to 0 decimals

Screenshot 2023-01-03 at 11.55.07
Screenshot 2023-01-03 at 11.55.21

Many thanks in advance
Dan