srizki
Well-known Member
- Joined
- Jan 14, 2003
- Messages
- 1,831
- Office Version
- 365
- Platform
- Windows
Cell B10 = 115.99 Amount Finance
Cell B11 = 24 Term
Cell B12 = 5.30%
Cell B13 = 4.84 Payment amount
I am using this formula,
=IF(B11=C40,B10-B13*(C40-1),0)
What I am saying is that if the corresponding cell in column C has 24, (or equally to 24), then b13 (4.84) * (24-1).
the problem is that when I do this calculation using a calculator I get the desire values of $4.67, on my spreadsheet it is $4.60, and that creating a 7 cents variance.
Please advise.
Best regards,
Cell B11 = 24 Term
Cell B12 = 5.30%
Cell B13 = 4.84 Payment amount
I am using this formula,
=IF(B11=C40,B10-B13*(C40-1),0)
What I am saying is that if the corresponding cell in column C has 24, (or equally to 24), then b13 (4.84) * (24-1).
the problem is that when I do this calculation using a calculator I get the desire values of $4.67, on my spreadsheet it is $4.60, and that creating a 7 cents variance.
Please advise.
Best regards,