Round up to a specific figure

  • Thread starter Thread starter Mick B
  • Start date Start date
M

Mick B

Hi, I need to round up a sheet of figures that will do the following: if a
figure is between £4.50 and £4.99, the figure will be rounded up to £5.00, or
if between £4.00 and £4.49, then rounded down to £4.00.

Any clues please?
 
assuming the value is in a1

=round(a1,0)

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Mick B" escreveu:
 
The goalposts have changed 9as they do). If an amount is say, £5.33 then it
needs to be rounded up to £5.35, but if it was £5.37 it needs to be rounded
up to £5.39, so the second decimal needs to be rounded up to either 5 or 9.

Does that make sense? Hope someone can assist
 

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

How can I Round up to the nearest .25 11
Lookup 9
repeated conversion of data summarized into rows and columns 4
Rounding Up to a specific number 3
Round up or down by set variable 3
Rounding up/down to .95 7
Cumulative time calculation in Excel 2003 2
Rounding to nearest 0.5 in Excel 2007 4

Back
Top