LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formulae, conditional formatting & macro security Kevin Lucas Excel Discussion (Misc queries) 7 March 15th 05 01:10 PM
Excel and CubeCell Formulae les Excel Discussion (Misc queries) 0 March 9th 05 11:28 AM
Advanced Find Command?? Debbie Excel Discussion (Misc queries) 1 February 4th 05 09:07 PM
Can Excel advanced filter be used in "and NOT" mode Robert Excel Worksheet Functions 1 January 27th 05 02:57 PM
vlookup change column index position - without changing formulae loopyloobyloo Excel Worksheet Functions 1 November 26th 04 01:35 PM


All times are GMT +1. The time now is 10:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"