Hi,

I am trying to reference an integer (number/decimal) in a NORMINV (inverse probability) formula which is:

s = Application.InputBox(prompt:="Enter your value", Type:=1)
k = s * 0.01

ActiveCell.Offset(0, 1).Formula = "=NORMINV(k,R" & LastRow - 1 & "C, R" & LastRow & "C)"
So, the input dialog asks for a number "s" (for example 95) which is then multiplied by 0.01 and then called "k", the problem is the formula is not recognizing k, it just puts k as k in the formula! How to use the obtained value of k in the formula? I mean what is the proper referencing for integers or numbers in the excel formula?

I declared k and s as string.

Thanks alot in advance!

Sanjeev