Hi,
i'm assigning a cell value based on another cell value by calculating with formula as below in c# programming
sheet3.Range["K3"].Formula = "=VALUE(RIGHT(K6,LEN(K6)-FIND('-',K6)))"
but unfortunately getting an exception like "Attempted to divide by zero." , i'm unable to trace this, please give me a solution to fix this formula.