Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Analysis Toolpak Question
I recently added the Analysis Tookpak and have noticed some problems. When using functions from ATP it will not show a popup that shows what you are supposed to put in the function. For example if you type in =IF( it will show a window that says: =IF(logical_test,[value_if_true],[value_if_false]) to remind you what to put in but if you type in for instance =randbetween( nothing shows up. I can go into the insert function menu to view the requirements but it is much easier to have it show up on the screen when you are trying to understand new functions. Is this just how it works or is it only happening on my computer? -- mphell0 ------------------------------------------------------------------------ mphell0's Profile: http://www.excelforum.com/member.php...o&userid=30153 View this thread: http://www.excelforum.com/showthread...hreadid=511029 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Analysis Toolpak Question
That's the way it is.
You do know about typing, for example, =randbetween( and then using CTRL+A to popup the Insert Function dialog? According to the Excel12 blog, in the next version all function are created equally best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "mphell0" wrote in message ... I recently added the Analysis Tookpak and have noticed some problems. When using functions from ATP it will not show a popup that shows what you are supposed to put in the function. For example if you type in =IF( it will show a window that says: =IF(logical_test,[value_if_true],[value_if_false]) to remind you what to put in but if you type in for instance =randbetween( nothing shows up. I can go into the insert function menu to view the requirements but it is much easier to have it show up on the screen when you are trying to understand new functions. Is this just how it works or is it only happening on my computer? -- mphell0 ------------------------------------------------------------------------ mphell0's Profile: http://www.excelforum.com/member.php...o&userid=30153 View this thread: http://www.excelforum.com/showthread...hreadid=511029 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Analysis Toolpak Question
Thanks Bernard, I did not know about the CTRL+A but I will use it a lot now. -- mphell0 ------------------------------------------------------------------------ mphell0's Profile: http://www.excelforum.com/member.php...o&userid=30153 View this thread: http://www.excelforum.com/showthread...hreadid=511029 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
unable to load "Excel" analysis toolpak tried the tools and brows | Excel Discussion (Misc queries) | |||
Analysis toolpak | Setting up and Configuration of Excel | |||
Analysis ToolPak installed but no Data Analysis option | Excel Discussion (Misc queries) |