Hi All,
I’m hoping someone can help me on this one. I have a requirement whereby I need to calculate a formula to convert from multiple currencies. For instance I need something that performs the following logic:
If Currency Euro>0 then multiple by exchange rate; OR; Currency USD>0 then multiply by exchange rate; OR; Currency YEN>0 Then multiple by Exchange rate. And so on and so on…
Is this even possible I’ve been wracking my brains over it for a couple of days now.
Any Help appreciated.
Thanks
Craig G
(Visited 474 times, 1 visits today)
Chanakya Jayabalan Answered question May 11, 2018
The simplest way would be using a calculated column. You could build all those if conditions with in your formula. Check out this link.
https://msdn.microsoft.com/en-us/library/office/bb862071(v=office.14).aspx
(Visited 1 times, 1 visits today)
Chanakya Jayabalan Answered question May 11, 2018
