| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| what is this formula means =+$R$16 | Excel Worksheet Functions | |||
| K-Means, X-Means or other Clustering Algorithms | Excel Programming | |||
| Can someone tell me what this formula means? | Excel Worksheet Functions | |||
| Can anyone tell me what this formula means? | Excel Discussion (Misc queries) | |||
| how to format zip codes (23838-1101) for a merge. | Excel Discussion (Misc queries) | |||
Linear Mode
