any formula

D

driller

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
 
D

Dave Peterson

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

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

driller

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 said:
=(A1:A3 C1:C3)
=IRR(A1:A10,343)

I don't understand the last portion (or numbers).
Click to expand...
 
D

Dave Peterson

I could use this:

=(INDIRECT(I1) INDIRECT(J1))

where I1 and J1 each held addresses.

I bet you can test it in your other formulas.
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
Click to expand...
 
D

driller

thanks it did work!
i hope you can help me with the next Q..any macro...
note: i apply to my work every precious thing learned in this forum...

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



Dave Peterson said:
I could use this:

=(INDIRECT(I1) INDIRECT(J1))

where I1 and J1 each held addresses.

I bet you can test it in your other formulas.
Click to expand...
 
Top