Hi all,
I'm currently facing with an issue while using the formula function. To make it easier to understand, I will show you an example.
The problem is I need to dynamic input the fx rate in the formula rather than write it in the formula function.
The original input would be like sheet one, and the fx rate would change every time I run the excel workflow, but I am not allowed to change the formula button once the workflow is uploaded to the gallery.
The output should be like this:
if [CURRENCY]='USD' then [REAL AMOUNT]*7.13 else [AMOUNT] endif
The ideal input and output sheets have been attached.
Appreciate it very much if you can tell me how to do with this, thank you.
