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 :slightly_smiling_face:

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 :slightly_smiling_face::blush:

@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

Please change it like this

"(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

Please use like this

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

cheers

1 Like

It’s work thank you so much

Cheers​:blush::blush::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