Hi,

=(IF(INT(((C4*F5*((L9-J5)/365/100)-INT(C4*F5*((L9-J5)/365/100)*10))))>4,C4*F5*((L9-J5)/365/100)+1),IF(INT(((C4*F5*((L9-J5)/365/100)-INT(C4*F5*((L9-J5)/365/100)*10-INT((C4*F5*((L9-J5)/365/100)*10))*10))))>4,C4*F5*((L9-J5)/365/100)+0.1),IF(INT(((C4*F5*((L9-J5)/365/100)-INT(C4*F5*((L9-J5)/365/100)*10-INT((C4*F5*((L9-J5)/365/100)*10))*10-(INT(((C4*F5*((L9-J5)/365/100)-INT(C4*F5*((L9-J5)/365/100)))*10-INT((C4*F5*((L9-J5)/365/100)-INT(C4*F5*((L9-J5)/365/100)))*10))*10)))*10)
))>4,C4*F5*((L9-J5)/365/100)+0.01))

There are there conditions here,what can i put to allow one to be carry out if is true.

What im doing is checking the decimal places of a number:

E.G: 1000.456

Check whether the first decimal place is >4,then add 1
Check whether the second decimal place is >4,then add o.1
Check whether the third decimal place is >4,then add o.o1

or else

Just round the number

All these are done in the same cell,is there a shorter way of doing this.Thanks a million!!