|
I found out that INT rounds down to the nearest integer. For example INT(8.1) =8, and INT(8.9)=8.
This equation will work in cell G2, with years in B2, and Interest Rate in G2:
=IF(INT(B2/5)-B2/5=0,G2+0.1,G1)
It will then work in all lower rows if you copy and paste.
So, if Bx is 5 or 10, or 15, etc, then Bx/5 is an integer. And INT(Bx)=Bx. Therefore, INT(Bx)-Bx=0.
__________________
Charlie
1966 912 Polo Red
1950 VW Bug
1983 VW Westfalia; 1989 VW Syncro Tristar Doka
Last edited by ckissick; 03-09-2010 at 07:10 AM..
|