I want to type an excel formula inside a particular cell using the “Type into Activity” .
This is the formula : =IF(ISERR(SEARCH("/",A2:A12)),VALUE(A2:A12),LEFT(A2:A12,SEARCH("/",A2:A12)-1)/RIGHT(A2:A12,SEARCH("/",A2:A12)-1))
I am not able to store the formula inside the “Type into activity” . I also tried with the assign activity but ended up with conversion errors…
All I need is just type this formula inside an Excel cell.
Can anyone help me on that… Its something URGENT!!! and I am stuck with this small error!!
(The Formula is used to convert fraction to decimal value)