Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulae, conditional formatting & macro security | Excel Discussion (Misc queries) | |||
Excel and CubeCell Formulae | Excel Discussion (Misc queries) | |||
Advanced Find Command?? | Excel Discussion (Misc queries) | |||
Can Excel advanced filter be used in "and NOT" mode | Excel Worksheet Functions | |||
vlookup change column index position - without changing formulae | Excel Worksheet Functions |