Round Up Formula Problem

C

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Round up price to end .99 2
Formula Problem 4
Rounding 4
MROUND to only round up 7
Round formula 1
How: Round to nearest 25 4
VLookup Within a Range 2
Round Function 5

Top