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:

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?

If your figure is in A1, then put this in B1

=INT(A1+0.5)

"Mick B" wrote:

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?

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

"Dennis" wrote:

If your figure is in A1, then put this in B1

=INT(A1+0.5)

"Mick B" wrote:

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?

Look in the help index for ROUND
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mick B" wrote in message
...
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?