what do these ---- {0.6,2,4,5,6,7,9} and {0,21,111,201,551,1101,2701}means in an excel formula?
 

The formula used is as below

=ROUND(MAX((T14-3500)*0.05*{0.6,2,4,5,6,7,9}-5*{0,21,111,201,551,1101,2701},0),2)

may i know what do these ---- {0.6,2,4,5,6,7,9} and {0,21,111,201,551,1101,2701} means in the formula above?

what do these ---- {0.6,2,4,5,6,7,9} and {0,21,111,201,551,1101,2701} means in an excel formula?
 

Think of it as an in-cell lookup array formula.

The curly brackets contain the lookup table and array.

Read help on MATCH for more and examples.

That's about it for my expertise<g

Gord



On Thu, 12 Dec 2013 20:33:50 -0800 (PST), Tiffany Teo
wrote:

The formula used is as below

=ROUND(MAX((T14-3500)*0.05*{0.6,2,4,5,6,7,9}-5*{0,21,111,201,551,1101,2701},0),2)

may i know what do these ---- {0.6,2,4,5,6,7,9} and {0,21,111,201,551,1101,2701} means in the formula above?