MinF
The MinF function returns the minimum value out of a set of expressions and conditions.
Syntax :
MINF(Value,[Condition])| Parameters | Description |
|---|---|
| MINF(Expression) | Returns the minimum values. |
| MINF(Expression,"Value<>' ') | Return the minimum value where value meets the condition stated. |
Examples :
Table Name : Products
| ProductID | Product Name | Price |
|---|---|---|
| 1 | Pen | 6 |
| 2 | Pencil | 3 |
| 3 | Eraser | 2 |
| 4 | Bottle | 5 |
| 5 | Book | 10 |
| 6 | Marker | 12 |
| 7 | Sheets | 4 |
Example 1
dMinF = MinF(Price)
Debug(MinF)Result :
dMinF
= 2Example 2
dMinF = MinF(Price,ProductName<>'Eraser')
DEBUG(dMinF)Result :
dMinF
= 3