Excel uses iteration to determine the ... and then click the "Up" arrow to increase the number of decimal points Excel will display. The RATE function can also be used to determine the periodic ...

Click Formulas on the left pane. Under the Calculations options section, check the Enable iterative calculation check box In the Maximum iterations box, type the number of times you want Excel to ...