entering advanced formulae
 

I am trying to enter the formula =(LOGINV(G8/10))^-1
but this does not work. Can anybody suggest the correct order for typing
tthis formula?

Hi

Try (-1) :
=(LOGINV(G8/10))^(-1)
.... it will at least give you some meaningful error messages ;-)

HTH. Best wishes Harald

"Confused" skrev i melding
...
I am trying to enter the formula =(LOGINV(G8/10))^-1
but this does not work. Can anybody suggest the correct order for typing
tthis formula?

What are you trying to accomplish? LOGINV takes three arguments, while
you only have one. From XL Help:

LOGINV
Returns the inverse of the lognormal cumulative distribution function
of x, where ln(x) is normally distributed with parameters mean and
standard_dev. If p = LOGNORMDIST(x,...) then LOGINV(p,...) = x.

LOGINV(probability,mean,standard_dev)



In article ,
"Confused" wrote:

I am trying to enter the formula =(LOGINV(G8/10))^-1
but this does not work. Can anybody suggest the correct order for typing
tthis formula?