Actually i am trying to make the dollar amount go up to the next nearest
nickel.
When i tried the ceiling function it went up more that what i wanted it
to.
The 1.17 should be 1.20
and another line was 1.13, should be 1.15.

Are you saying this doesn't work for you...

=CEILING(A1,0.05)

where the amount being rounded is assumed to be in A1?

Rick