entering advanced formulae

C

Confused

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?
 
H

Harald Staff

Hi

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

HTH. Best wishes Harald
 
J

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)
Click to expand...
 
Top