Hello All,
I am looking for some help writing a formula to a cell in an excel spreadsheet. I have been able to do this with simple formulas, so I know I am doing the procedure correct, and I know the formula works when I type it into an excel sheet.
However when I try to use the write cell function in uipath, I get a message saying the range doesn’t exist. If I delete this formula and type in a more simple one i.e. =J2+J3 it works fine. I think it may have something to do with the special characters in the formula. Any help would be appreciated. Here is the formula.
=IFERROR(4555.635783*((2*ASIN(SQRT((SIN((RADIANS(VLOOKUP($N$2,Sheet2!$B$1:$D$65389,2,FALSE))-RADIANS(VLOOKUP(F2,Sheet2!$B$1:$D$65389,2,FALSE)))/2)^2)+COS(RADIANS(VLOOKUP($N$2,Sheet2!$B$1:$D$65389,2,FALSE)))COS(RADIANS(VLOOKUP(F2,Sheet2!$B$1:$D$65389,2,FALSE)))(SIN((RADIANS(VLOOKUP($N$2,Sheet2!$B$1:$D$65389,3,FALSE))-RADIANS(VLOOKUP(F2,Sheet2!$B$1:$D$65839,3,FALSE)))/2)^2))))),“”)
Extra points if you can figure out what the formula does lol