On Wednesday, June 11, 2014 4:35:08 PM UTC-4, lel999 wrote:
What does { } mean in excel formulas?

Garry and joeu2004, thank you both for your answers!

I have seen the curly braces in the context of a Formula Bar. What I
still struggle to understand is what purpose does it serve?

Thanks again!

Joeu2004 gives a more complete explanation than I gave you as the curly
braces can also be used as he described for the purpose of letting
Excel's calc engine know an array ref is being used. Excel's calc
engine handles arrays differently than it handles ranges, so it can
correctly return the expected results.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion