Support Board
Date/Time: Tue, 04 Nov 2025 22:42:40 +0000
Post From: SMALL() function example usage
| [2022-12-22 22:47:09] |
| User562383 - Posts: 10 |
|
I am trying to use the spreadsheet formula study to find the second smallest value of four values using the small() spreadsheet formula function https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#SMALL_Function but I keep getting 0 as the output Examples I've tried SMALL(ID11.SG1,ID10.SG1,ID9.SG1,ID13.SG1,2) SMALL([ID11.SG1,ID10.SG1,ID9.SG1,ID13.SG1],2) SMALL((ID11.SG1,ID10.SG1,ID9.SG1,ID13.SG1),2) How do I input an array as the first argument? |