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)
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
Hope the above give you what you need
Let me know if you need anything in addition
Many thanks Dan
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
