Hi,
I'm working on the value of cent which return to the value of 0 or 5 cents.
e.g. $0.03 = $0.05 or $0.08 = $0.10 etc. So use the following formula that
works for me.

B5 = $1.02
C5 =
IF(VALUE(RIGHT(TEXT(TRUNC(B5,2),"0.00"),1))5,TRUN C(B5,1)+0.1,IF(VALUE(RIGHT(TEXT(TRUNC(B5,2),"0.00" ),1))0,TRUNC(B5,1)+0.05,B5))
which is equal to $1.05

Can anyone help to make it shorter?

Thanks