Roundup to nearest 250

H

Hall

I have list of numbers that need to be rounded up to the nearest 250.

For example:
1033->1250
600->750
25->250
2600->2750
1000->1000

What's a formula for that?
 
B

Bob Phillips

=CEILING(A10,250)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

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

Calculate the median value before a specified list 0
calculating age of debt (30,60,90 days) 1
Rounding to nearest 250 by 125s 3
matching a customer with a twist.. 1
Tiered Pricing Formulae - is this possible? 4
Monthly Percent Increase 1
Roundup formula question 3
Pivot Table External Data % Problem 8

Top