How to calculate percentage in Uipath excel file

Hii guyz …I am new to UiPath …please help me to how to calculate percentage of multiple columns such as
I have I have 7 subjects marks And I want calculate total then then calculate percentage

@Sanket_RPA

Welcome to the community

You can use excel formulas for this

Use a write cell with value as `"=Sum(E2:J2)"` and the cell as `"k2"`

And then use auto fill range K2:K11 then all the rows will have sum

And for percentage… use write cell again on L2 with value as `"K2/600"`assuming total is 600 change accordingly

And use auto fillrange again

Cheers

1 Like

Thank you so much for your valuable Suggestions

1 Like

Use Write cell activity:
(SUM(E2:J2)/600)*100&“%”

Thanks

4 Likes

Thanks alot Kalpesh

1 Like

Again I have to count AT_KT for if subjects marks is < 40 then aAT KT count become 1 for one subject, If two subjects marks is <40 AT KT count should be become 2 …

In Advanced Thank you so much

@Sanket_RPA

Please try this.approach would be same again

`=COUNTIFS(E2:J2,">40")`

Hope this helps. please mark if donr else if any errors happy to help

Cheers

1 Like

Hello Kalpesh I am calculating percentage this showing error

@Sanket_RPA

`"(SUM(E2:J2)/600)*100"`

cheers

1 Like

Work after I did like this =sum(E2:J2)/600*100

Thank you so much Anil Sir
Cheers

1 Like

I want only 2 digits after .decimal

@Sanket_RPA

Use `"=ROUND((SUM(E2:J2)/600)*100,2)"`

cheers

1 Like

Countif not working help me to solve this error

@Sanket_RPA

`"=COUNTIF(E2:J2,""<40"")"`

cheers

1 Like

It’s work thank you so much

Cheers​:blush:

1 Like

I have used rank function to do ranking as per the Percentage…
=RANK(L2,L2:L11,0)
But it return duplicate value too …such as 1111 22 in column instead of unique ranking vise

Cheers

@Sanket_RPA

Try this

`"=RANK(L2,\$L\$2:\$L\$11,0)"`

cheers

1 Like

Hii I want to right NA in rank column who has atkt…how to do that help me

Cheers

@Sanket_RPA

Please use this. and please try to amintain one topic for one question.that way it would help to understand the conversation to others as well

`"=IF(M2>0,=RANK(L2,\$L\$2:\$L\$11,0),""NA"")"`

Please mark as resolved if solved. And for subsequent questions on other topics feel free to open a new ticket/topic

cheers

1 Like

strDate = “UiPath, RPA.Developer”

I want to replace . Dot where is comma, and in .dot replace with comma
How ?

Cheers