entering advanced formulae

[Guest]

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?

 

[Harald Staff]

Hi

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

HTH. Best wishes Harald

 

[JE McGimpsey]

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)