# MINIF 函式

## 基本用法

`pivot value: MINIF(testScores, testCount >= 3) group:studentId limit:1`

## 語法

`pivot value:MINIF(col_ref, test_expression) [group:group_col_ref] [limit:limit_count]`

col_ref字串參照您要求取值的資料欄。
test_expression字串用來求取值的運算式，必須解析為 `true``false`

## 範例

### 範例 - 條件計算函式

• `AVERAGEIF` - 符合指定條件且依群組區分的一組值的平均值，請參閱 AVERAGEIF 函式
• `MINIF` - 符合指定條件且依群組區分的一組值的最小值。請參閱 MINIF 函式
• `MAXIF` - 符合指定條件且依群組區分的一組值的最大值。請參閱 MAXIF 函式
• `VARIF` - 符合指定條件且依群組區分的一組值的變異數。請參閱 VARIF 函式
• `STDEVIF` - 符合指定條件且依群組區分的一組值的標準差。請參閱 STDEVIF 函式

datecityraintempwind
1/23/17Valleyville0.0012.86.7
1/23/17Center Town0.319.45.3
1/23/17Magic Mountain0.000.07.3
1/24/17Valleyville0.2517.23.3
1/24/17Center Town0.541.17.6
1/24/17Magic Mountain0.325.08.8
1/25/17Valleyville0.023.36.8
1/25/17Center Town0.833.35.1
1/25/17Magic Mountain0.59-1.76.4
1/26/17Valleyville1.0815.04.2
1/26/17Center Town0.966.17.6
1/26/17Magic Mountain0.77-3.93.0
1/27/17Valleyville1.007.22.8
1/27/17Center Town1.3220.00.2
1/27/17Magic Mountain0.775.65.2
1/28/17Valleyville0.12-6.15.1
1/28/17Center Town0.145.04.9
1/28/17Magic Mountain1.501.10.4
1/29/17Valleyville0.3613.37.3
1/29/17Center Town0.756.19.0
1/29/17Magic Mountain0.603.36.0

`derive type:single value:AVERAGEIF(temp, rain > 0) group:city as:'avgTempWRain'`

`derive type:single value:MAXIF(wind,temp < 0) group:city as:'maxWindSubZero'`

`derive type:single value:MINIF(temp,wind<5) group:city as:'minTempWind5'`

`derive type:single value:VARIF(temp,rain >0) group:city as:'varTempWRain'`

`derive type:single value:STDEVIF(rain,city=='Center Town') as:'stDevRainCT'`

`set col:stDevRainCenterTown,maxWindSubZero value:numformat(\$col,'##.##')`

`set col:varTempWRain,avgTempWRain,minTempWind5 value:numformat(\$col,'##.#')`

datecityraintempwindavgTempWRainmaxWindSubZerominTempWind5varTempWRainstDevRainCT
1/23/17Valleyville0.0012.86.78.35.17.263.80.37
1/23/17Center Town0.319.45.37.3 532.60.37
1/23/17Magic Mountain0.000.07.31.66.43-3.9120.37
1/24/17Valleyville0.2517.23.38.35.17.263.80.37
1/24/17Center Town0.541.17.67.3 532.60.37
1/24/17Magic Mountain0.325.08.81.66.43-3.9120.37
1/25/17Valleyville0.023.36.88.35.17.263.80.37
1/25/17Center Town0.833.35.17.3 532.60.37
1/25/17Magic Mountain0.59-1.76.41.66.43-3.9120.37
1/26/17Valleyville1.0815.04.28.35.17.263.80.37
1/26/17Center Town0.966.17.67.3 532.60.37
1/26/17Magic Mountain0.77-3.93.01.66.43-3.9120.37
1/27/17Valleyville1.007.22.88.35.17.263.80.37
1/27/17Center Town1.3220.00.27.3 532.60.37
1/27/17Magic Mountain0.775.65.21.66.43-3.9120.37
1/28/17Valleyville0.12-6.15.18.35.17.263.80.37
1/28/17Center Town0.145.04.97.3 532.60.37
1/28/17Magic Mountain1.501.10.41.66.43-3.9120.37
1/29/17Valleyville0.3613.37.38.35.17.263.80.37
1/29/17Center Town0.756.19.07.3 532.60.37
1/29/17Magic Mountain0.603.36.01.66.43-3.9120.37