Round Up Formula Problem

[cakonopka]

I want to make a round up formula that will round up prices to the
nearest £5. For example round 13.70 to £15. Would appreciate someone
telling me how to do this.

Many Thanks in Advance

Chris

 

[swatsp0p]

Use the CEILING function, as:

=CEILING(A1,5)

13.7=15
15.1=20

 

[cakonopka]

Thanks ever so muchm works a treat,

Cheers