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

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

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What do these numbers mean in the rounding formula? 2
Export BPMN Visio Chart to Excel 0
What is "--" in Excel Formula (SUMPRODUCT) 2
Embed the same Excel multiple times 0
Cumulative formula for word table 0
MS Project. Real progress of the project, % complete 1
Autonumber field in Excel that behaves the same as Access 0
VBA - (re-) Set a Table Style 2

Top