Values Comparision in Excel

Hi Team,
I have an Excel created as below:
Capture

Now I want to first round off 3rd column value to 2 digits and then compare 3rd col (compOffHrs) to 2nd col (fltNightCompoff). How can we achieve this ?
And how can perform mathematical operations like Multiply two values ? Please help.

Thanks,
Vignatha

Hi,

You can use excel recorder activity to achieve your use case. ROUND function will help you in rounding value to required number of decimal. PRODUCT function will help you in getting multiplication value

Regards,
Amit Anand

Should we use Excel Recorder only as a new process ?
Issue is as I try to use it after few activities in a process nothing is happening after I record and click “Open in Studio”. Could you please suggest.

Hi,

When you record some steps using excel recorder and click Open in Studio then system will create new process and add Excel recorder block there. It iwll also create some arguments which will be visible in argument tab.

You can copy paste the block and arguments in another process if you wish

Regards,
Amit Anand