=(A1:A3 C1:C3)
=IRR(A1:A10,343)

I don't understand the last portion (or numbers).

driller wrote:

hello again,

after reply and reading previous posts...anyone please give me ONE sample
SIMPLE formula that can produce results either error results "#NULL! or
#NUM!" or numbers as desired result.....

Just reviewing how it can work with an iteration...

regards,
driller

--
*****
birds of the same feather flock together..

--

Dave Peterson