MS Excel: Advanced Functions
1>> Round Function =ROUND(cell,number of digits to round) i.e. cell D2 = 45.256 =round(d2,1) would return 45.3 =round(d2,2) would return 45.26 =round(d2,-1) would return 50 =round(d2,-2) would return 0 2>> Payment Function =PMT(interest rate,total number of payments,principal,future value,type) Type is a 0 or 1 indicting when the payment is due. 0 or omitted = At the end of the period 1 = At the beginning of the period Future value and type are optional arguments. Note: be sure interest for year is divided by 12 Note: PMT function should be preceded by a minus to display a positive number. 3>> Countif Function The countif function will count how many cells within a range meet the criteria or test. COUNTIF(range,criteria) Range = range to check Criteria = test 4>> If Function A simple If function will allow a cell to change depending on a conditional test. =IF(test, what to do if it is true, what to do if it is false) 5>> Embedded If