| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
any formula
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.. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
any formula
=(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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
any formula
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
any formula
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. driller wrote: 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 -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
any formula
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" wrote: 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. driller wrote: 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 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
