Excel multiplication and addition

Help
1

Please find the attached excel document.We need to output for this excel calculation.!

example
example1280×1024 85.8 KB

2

@gokult

  1. Read excel document with starting range as A4 and assign output to datatable.
  2. Use for each row loop to get each from datatable.
    3) using if condition check the month hrs column in each row has null value, if it contains
    null value don’t do any operations.( Place statements in 3rd and 4th point in else block
    of if statement)
    4) Using assign activity
    variable1 = (88 * Cint(row(3)))/100
    row(5)=variable1
    above statement calculates 88% of month hrs and stores it to percentage column.
    5) Using assign activity.
    row(6)=Cint(row(4))*variable1
    above statement calculates total and stores it in total column.
  3. After for each write the same datatable to excel with starting range as A4(Check the include column headers)
3

Hi Manjuts90,

Thanks for your update. I will check and let you know

4

@gokult,

You can write macro it’s an easy way than reading excel, calculating so on.

Cheers,
Pankaj

5

Hi Manjuts90,

As per your instruction I made the changes, but still getting the following error:

Source : Multiplication

Message : Input string was not in a correct formaterror

6

@gokult That error happening due to conversion of input or bad input. Can u post ur workflow and excel?

7

MultiplyTwoNumbers (1).xaml (12.0 KB)sample1.xls (28.5 KB)

8

@gokult Check is below workflow once, let me know.

MultiplyTwoNumbers (1).xaml (17.8 KB)

9

HI Manjuts90,

Thank you so much.

It’s working too good.

1 Like
10

@gokult Check below workflow also, this is differ from above workflow. I have just edited your workflow.

MultiplyTwoNumbers (1).xaml (13.0 KB)

1 Like
11

Hi Manjuts90,

Sorry for that inconvenient, now subtotal is not working please check and let me know…

percentage = 88% from monthhrs

Total = rates*percentage.

Please check the calculation part…

12

@gokult Are u talking about excel formula u have used To sum values in cells?

13

Hi manjuts90,

I need your help for calculation part in uipath

percentage = 88% from monthhrs

Total = rates*percentage.

Please check the calculation part…

14

@gokult Are you getting wrong values in both workflows?

15

@Manjuts90 yes.:frowning:

example
example1280×1024 85.8 KB

Please find the attached excel sheet.

This is the proper format for output

16

@gokult r u saying u want value like below.

Percentage= (40 * 88)/100 for employee 001

total= percentage * 8 for employee 001
is it correct?

17

@Manjuts90 absolutly correct

18

@gokult try below one and let me know.

MultiplyTwoNumbers (1).xaml (13.0 KB)

19

@Manjuts90 total and percentage field is working good.

Then i need subtotal also.

please help me

20

@gokult You required only value in G15 cell right?