hi all,

is there a loop structure of some sort that can be used in cell formulas?

ie
=for(from,to,loop_calculation)

or something similar?

i searched through the online help and on the web but all i came up with was
vba loops

any help is greatly appreciated!

thanks!!

J

Arrayformulas will do something like that:

=SUM(--(A1:A103))

Entered with Ctrl+shift+Enter rather than just enter

would get the count of cells in A1:A10 that have a value greater than 3.

the -- just converts the boolean results to 0 or 1's so they can be summed.

put the formula in a cell and enter with Ctrl+Shift+enter. Now select the
cell and highlight A1:A103 in the formula bar. Hit F9 to evaluate that
section. You should get an array of True and False values. hit escape.
Now highlight --(A1:A103) and hit F9. You should see an array of zeros
and 1's. Hit escape to return to the formula.


--
Regards,
Tom Ogilvy


"Gixxer_J_97" wrote in message
...
hi all,

is there a loop structure of some sort that can be used in cell formulas?

ie
=for(from,to,loop_calculation)

or something similar?

i searched through the online help and on the web but all i came up with
was
vba loops

any help is greatly appreciated!

thanks!!

J