IRR error

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Haddo@officeformac.com - 06 Mar 2009 14:55 GMT

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

Using the IRR formula is coming back with a num error message. I know on a PC that add-ins have to be activated to use this, but there is nothing in the add-ins part of the menu. Does anyone know what I'm doing wrong?

Thank you for any help you can give.

Reply to this Message

Bob Greenblatt - 06 Mar 2009 18:21 GMT

On 3/6/09 9:55 AM, in article 59b6ea1a.-1@webcrossing.caR9absDaxw,

> Version: 2008
> Operating System: Mac OS X 10.5 (Leopard)
[quoted text clipped - 4 lines]
>
> Thank you for any help you can give.

We have no idea what you are doing wrong until us what the formula is, and
what the cell contents it refers to are. Have you looked in Excel help?

Signature

Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

Reply to this Message

Haddo@officeformac.com - 07 Mar 2009 12:00 GMT

I am using the =IRR formula with a purchase price of a property, then a range of income and then the sale price.

I've used Excel Help but it doesn't mention the errors.

Thank you for responding

> On 3/6/09 9:55 AM, in article 59b6ea1a.-1@webcrossing.caR9absDaxw,
> "Haddo@officeformac.com" wrote:
[quoted text clipped - 13 lines]
> Bob Greenblatt [MVP], Macintosh
> bobgreenblattATmsnDOTcom

Reply to this Message

Bob Greenblatt - 09 Mar 2009 13:43 GMT

On 3/7/09 8:00 AM, in article 59b6ea1a.1@webcrossing.caR9absDaxw,

> I am using the =IRR formula with a purchase price of a property, then a range
> of income and then the sale price.
[quoted text clipped - 21 lines]
>> Bob Greenblatt [MVP], Macintosh
>> bobgreenblattATmsnDOTcom

Again, please supply the exact formula, and the values for all the data it
references. Nobody can help you if we don't know what the data is.

Signature

Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

Reply to this Message

Mac Forum / Applications / Excel / March 2009

IRR error