close
課程時間:第十八週 2015/07/07
課程重點:
●數學函數
○RANDBETWEEN(Bottom,Top)
○RAND()
○SUMIF(Range,Criteria,Sum_range)
○SUMIFS(Sum_range,Criteria_range1,Criteria1,Criteria_range2,Criteria2,......)
○COUNT(Value1,Value2,......)
○COUNTIF(Range,Criteria)
○COUNTIFS(Criteria_range1,Criteria1,Criteria_range2,Criteria2,......)
○BINOMDIST(Number_s,Trials,Probablity_s,Cumulative)
○HYPGEOMDIST(Sample_s,Number_sample,Population_s,Number_pop)
全站熱搜
留言列表