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?
|