Convert a formula to UDF Function

[jonsonbero]

Thanks sir . I wasn't clear in my question.... Apologies!
In your codes I have added this line

Application.Volatile

Now I could get it completely ..thanks a lot for great help