help needed for Internal rate of return

Posted to microsoft.public.excel.worksheet.functions

No News

Posts: n/a

help needed for Internal rate of return

Hi.

I am new to this group.

I am having the values in cells a1 to a23 . 1000 in each cell

In the a24 cell the value entered was 24000

Now I want to have the INTERNAL RATE OF RETURN in the cell a25

I put the formula as =IRR(a1:a24)

Now I have the following error.

"The formula or function used is dividing by zero or empty cell"

Any help is awaited.

TT

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
FVSCHEDULE should allow cell reference for interest rate schedule	Philipm	Excel Worksheet Functions	1	January 25th 06 10:20 AM
"In Today's Dollars" help needed...	Rick B	Excel Worksheet Functions	4	January 12th 06 04:08 PM
XNPV vs. NPV(quarterly) different results	magis	Excel Worksheet Functions	3	January 6th 06 05:21 PM
Real RATE of return using =RATE illusive, inflation adjusted inflo	Pro - Land	Excel Worksheet Functions	4	November 1st 05 03:06 AM
How do create a formula to evalute a # to return 1 of 4 conditions	Larry	Excel Worksheet Functions	4	May 29th 05 12:58 AM

All times are GMT +1. The time now is 11:42 PM.

Menu

About Us