How to perform Excel formular in Excel /

Help Studio
1

Template:

May I ask is it possible to insert excel formular into it? Can anyone can share the workflow to me if it’s possible.

Excel:

Workflow:

2

Hi @Happydayyy

Please find this workflow as per your requirement it is working fine.
Let me know is it working on your side or not.

Task Excel.zip (3.2 KB)

Cheers!

4

Thank you very much, but I do have another issue is that I need to round the figure of the result (column I) in 5 decimal places. How I can edit it from your / my recent workflow?

5

Just record an macro for the same in excel and save it in a notepad and pass that notepad in invoke vba activity.

6

Hi @Happydayyy

How about the following?

image
image900×1197 55.2 KB

image
image1090×344 17.1 KB

Output:

template looking up updated.xlsx (82.1 KB)

Cheers!!

7

Thanks you so much.
But I only want data in specific column (I) to be 5 decimal places, how do I edit?

8

Now my workflow as this:

Output:

But I only want column I to be 5 d.p. , how I can edit?

9

@Happydayyy

Try this

image
image900×1197 55.7 KB

image
image1098×364 17.6 KB

10

@Happydayyy

Sequence5.xaml (12.3 KB)

Output:

template looking up updated.xlsx (81.9 KB)

Regards,

11

But still all column take 5 d.p

My updated workflow:

12

@Happydayyy

It doesn’t change for all columns please check because we mentioned that I:I Column only. Can you please provide input excel once.

13

template looking up 3.0.xlsx (90.3 KB)
The output sheet is “MU for__”
Thanks

14

@Happydayyy

Input

image
image1431×737 41.9 KB

Output

image
image1370×725 41.4 KB

I didn’t see changes in all columns only “I” column will be changes could you please confirm with this

15

I only want column I to be 5 d.p., column A, E,F, G,H just remain unchange (no need get 5 d.p , only need to get original data from source sheet)

Can you help me to cope with this issue, thanks you very much!

16

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.