Currently this code is for : H2 = (G2/G3), H4 = (G4/G5), H6 = (G6/G7), H8 = (G8/G9)
However, if i need to revise the excel outcome to:
H2 = (G2+G3)/2, H4 = (G4+G5)/2, H6 = (G6+G7)/2, H8 = (G8+G9)/2…etc, How I can edit the formular as above figure?
Many thxxx
My robot:
MU-bias standalone _Finalised.xaml (91.6 KB)
You need to first create the Excel template which should contain all the formula
then you copy the template and put your all the input its calculate base on formula, which save your time and during Change in code you have to update formula in excel not to change in UiPath
@Happydayyy I hope it solve your issue
it is hard for me to create a new one. As this robot is a finalized version and what I now do is only revise the formular in the robot, but i am confused how i can rewrite the formular as mentioned before.
Hope anyone can help me! Many thanks!!!
@Happydayyy you give me excel file which working as per your attached UiPath code
Robot:
Main MU-bias (combined count (after confi. table).xaml (74.4 KB)
(use this robot ver. as sample)
Many Thanks!!!
Thanks for update let me try this
Try this in Write Range activity.
"=(G"+(No+1).ToString+"+G"+(No+2).ToString+")/2"
Thanks,
Ashok 
Thank you so much.
If i hv another issue, may u guys help me as well?
Many thxxxx!!!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.