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

  • Thread starter Thread starter Tiffany Teo
  • Start date Start date
T

Tiffany Teo

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