Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Why is the value truncated to two significant figures when I try to calculate a monthly interest rate?

0
Posted

Why is the value truncated to two significant figures when I try to calculate a monthly interest rate?

0

When you switch to financial mode, the display automatically switches to Finance mode (i.e. two decimal places). This means that if you calculate a monthly interest rate (which is likely to be some fraction of one percent) there is not sufficient accuracy unless you flip back to decimal mode. To change to monthly interest rate, use the buttons on the rates dialog which converts without losing accuracy. From version 5.6 onwards the rate for monthly interest and other periods is computed automatically when the appropriate settings are made in the Rate dialog box.

Related Questions

What is your question?

*Sadly, we had to bring back ads too. Hopefully more targeted.