Read Excel sheet and do calculus operations based on condtions

Hi Uipath,

I’m new to uipath and doing the excersies. Im getting error for the below condtions.

Read the excel sheet. Add a new column Result. If number 1 > number 2, subtract, else multiply them.

  1. Expect a tax rate of 7.5%. Add another column that adds the tax rate to the result. and calculation should be done in the Windows calculator

kindly let me know the process for it. How to do?
NOTE: As Im new to this forum unable to attch documents and my code.

Hi ,

The calculation are in excel so it can be done using autofill .

  1. Write cell with the required formula .“=IF(A2>B2,A2-B2,A2*B2)”
  2. Autofill Range can be used for the rest of the column value .

I am herewith attaching the sample files.
Book1.xlsx (9.7 KB)
ExcelFill.xaml (5.4 KB)

Happy Automation :slight_smile:

Thanks and Regards,
Priyanka Ramesh.