Department of Computer Science and Engineering



EXCEL SYNTAXFunctionsAND(logical1, [logical2],…)AVERAGE(number1, [number2]…)COUNT(value1, [value2],…)COUNTA(value1, [value2],…)SUM(number1, [number2],…)COUNTIF(range, criteria)SUMIF(criteria_range, criteria, [sum_range])AVERAGEIF(range, criteria, [average_range])IF(logical_test,[value_if_true],[value_if_false])LOOKUP(lookup_value, array)ROUND(number,num_digits)MAX(number1, [number2],…)MIN(number1, [number2],…)NOT(logical)OR(logical1, [logical2],…)FV(rate, nper, pmt, [pv], [type])NPER(rate, pmt, pv, [fv], [type])PMT(rate, nper, pv, [fv], [type])PV(rate, nper, pmt, [fv], [type])RATE(nper, pmt, pv, [fv], [type]) ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download