Use an variable in the formula

[Paddi]

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.

[ShankerV]

Hi @Paddi 

I will suggest to copy the Fx rate in all the below cells and make the formula tool to work as

[REAL AMOUNT]*[Fx Rate]

Many thanks

Shanker V

[ShankerV]

@Paddi 

Please find the input:

Workflow:

Output:

Many thanks

Shanker V

[ShankerV]

@Paddi 

Step 1: Input

Step 2: Multi-Row formula

Step 3: 

Output: 

Hope your issue is resolved. Feel free to mark helpful answers as a solution, so that future users with the same issue can find them easier!!!!

Many thanks

Shanker V

[KrishnaChithrathil · Accepted solution]

@Paddi 

[Paddi]

hihi @KrishnaChithrathil  It works, thank you!

[Paddi]

hihi @ShankerV  Well solved, thank you.

[KrishnaChithrathil]

@Paddi 

Please mark all the posts which helped you as a solution. 🙂