thanks for quick reply...

I just wonder, never tried yet, is it possible to use function like *indirect*
in your sample formula so i can assume that this *intersection formula* can
be dynamic...
=(A1:A3 C1:C3) <<<-----result is #NULL!
=(A1:A3 a3:C3) <<<-----result is not an error!

a)can an indirect function available to work on the above ?
b)can the above formula be read if joined with some functioon something in a
formula like this...
=if((A1:A3 a3:C3)10,"re-iterate","Okey Juan"))

hope it make sense...

regards,
driller
--
*****
birds of the same feather flock together..



"Dave Peterson" wrote:

=(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