How to Use Integers/number Referencing in Excel VBA Formula??

Hi,

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

Please Login or Register  to view this content.

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

Hi

your k is inside inverted commas so appears as text.

Try:-

Please Login or Register  to view this content.

Thanks mehmetcik and Gary's Student for your replies.

The formula gives error even when i put k in double quotes:

Please Login or Register  to view this content.

I don't know why?

I solved the problem by putting the value of k in a cell and absolute referencing the cell location in the formula!

Here it is:

Please Login or Register  to view this content.

It worked! Thanks for your help.