 |
|
|
|
Next: full control of vert-axis
|
| Author |
Message |
External
Since: Mar 07, 2004
Posts: 1
|
(Msg. 1) Posted: Sun Mar 07, 2004 8:33 pm
Post subject: Add-ins for MS Excel for Mac/financial functions
Archived from groups: microsoft>public>mac>office>excel (more info?)
|
|
|
I colleague created an Excel file on MS-windows which includes several
financial functions e.g. YIELD, DURATION, PRICE, etc. The spreadsheet
opens but all those cells say #NAME? -- clearly the functions aren't
built in and didn't make the transition.
How to access those functions? On my Tools/Add-ins menu, the only one
is "Euro-currency tool." |
|
| Back to top |
|
 | |
External
Since: Mar 07, 2004
Posts: 2394
|
(Msg. 2) Posted: Mon Mar 08, 2004 2:39 am
Post subject: Re: Add-ins for MS Excel for Mac/financial functions [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
In article <89e93975.0403071733.cb5d5d6.RemoveThis@posting.google.com>,
danielandrachel.RemoveThis@mac.com (dan) wrote:
> I colleague created an Excel file on MS-windows which includes several
> financial functions e.g. YIELD, DURATION, PRICE, etc. The spreadsheet
> opens but all those cells say #NAME? -- clearly the functions aren't
> built in and didn't make the transition.
>
> How to access those functions? On my Tools/Add-ins menu, the only one
> is "Euro-currency tool."
While I certainly don't want to insult you, I'm going to risk chiding
you a bit...
In the past, MS application Help has been at best mediocre, more usually
abominable. However, starting with XL98, Help has been getting better
and better, and Mac users need to start using it like our Windows
counterparts do.
From XL Help:
> YIELD
> Returns the yield on a security that pays periodic interest.
> Use YIELD to calculate bond yield.
> If this function is not available, and returns the #NAME? error,
> install and load the Analysis ToolPak add-in.
There's a link there that tells you how, but from your message, you
already know.<!-- ~MESSAGE_AFTER~ --> |
|
| Back to top |
|
| |
External
Since: Nov 05, 2003
Posts: 482
|
(Msg. 3) Posted: Mon Mar 08, 2004 6:51 am
Post subject: Re: Add-ins for MS Excel for Mac/financial functions [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
You didn't insult me and I appreciate the response.
On my Tools/Add-ins menu, there is no link that tells me how to load
the "Analysis" tool-pak. There is a SELECT... button, but I do not know
where the "Analysis" tool-pak resides (as I mentioned in my initial
post).. I am willing to risk being chided again - where is it?
>-----Original Message-----
>In article <89e93975.0403071733.cb5d5d6.DeleteThis@posting.google.com>,
> danielandrachel.DeleteThis@mac.com (dan) wrote:
>
>> I colleague created an Excel file on MS-windows which includes
several
>> financial functions e.g. YIELD, DURATION, PRICE, etc. The
spreadsheet
>> opens but all those cells say #NAME? -- clearly the functions aren't
>> built in and didn't make the transition.
>>
>> How to access those functions? On my Tools/Add-ins menu, the
only one
>> is "Euro-currency tool."
>
>While I certainly don't want to insult you, I'm going to risk chiding
>you a bit...
>
>In the past, MS application Help has been at best mediocre, more
usually
>abominable. However, starting with XL98, Help has been getting
better
>and better, and Mac users need to start using it like our Windows
>counterparts do.
>
>From XL Help:
>
>> YIELD
>> Returns the yield on a security that pays periodic interest.
>> Use YIELD to calculate bond yield.
>> If this function is not available, and returns the #NAME? error,
>> install and load the Analysis ToolPak add-in.
>
>There's a link there that tells you how, but from your message, you
>already know.
>.
><!-- ~MESSAGE_AFTER~ --> >> Stay informed about: Add-ins for MS Excel for Mac/financial functions |
|
| Back to top |
|
| |
External
Since: Mar 07, 2004
Posts: 2394
|
(Msg. 4) Posted: Mon Mar 08, 2004 10:07 am
Post subject: Re: Add-ins for MS Excel for Mac/financial functions [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
In article <8c4b01c40503$ba788d80$a001280a@phx.gbl>,
<anonymous DeleteThis @discussions.microsoft.com> wrote:
> You didn't insult me and I appreciate the response.
> On my Tools/Add-ins menu, there is no link that tells me how to load
> the "Analysis" tool-pak. There is a SELECT... button, but I do not know
> where the "Analysis" tool-pak resides (as I mentioned in my initial
> post).. I am willing to risk being chided again - where is it?
Still didn't look at Help, eh?
If you follow the link on, say, the Yield, page:
> Install and load the Analysis ToolPak
> Before using an analysis tool, you must arrange the data you want to
> analyze in columns or rows on your worksheet. This is your input
> range.
> If the Data Analysis command is not on the Tools menu, you need to
> install the Analysis ToolPak in Microsoft Excel.
> To install the Analysis ToolPak
> 1. On the Tools menu, click Add-Ins.
> 2. Select the Analysis ToolPak check box.
> If Analysis ToolPak is not listed in the Add-Ins dialog box, use the
> Setup Assistant to install the Excel Add-ins component. For step 5
> (Installation) of the Setup Assistant, expand Office Tools by
> clicking the arrow next to it, and then select the Excel Add-ins
> check box
Instead of the Setup Assistant, though, look for the Value Pack
installer inside the Value Pack folder which can be found on your
Install CD<!-- ~MESSAGE_AFTER~ --> >> Stay informed about: Add-ins for MS Excel for Mac/financial functions |
|
| Back to top |
|
| |
|
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum
|
|
|
|
|
|
|
FAQ
Profile
Private Messages
Log in
