Rounding Up to Nearest Half or Whole

C

calummurdo

Hi There,

I'm trying to find a way to round a value up to the nearest half or
whole number. For example,

1.3333 would round to 1.5 or
2.6 would round to 3.0 or
3.0 would round to 3.0

I've looked at the normal rounding functions but don't see how this can
be acheived, MROUND looked promising but didn't seem to hit the nail on
the head. Do you have any ideas that can help?

Thanks very much,

CalumMurdo
 
B

Bondi

Hi There,

I'm trying to find a way to round a value up to the nearest half or
whole number. For example,

1.3333 would round to 1.5 or
2.6 would round to 3.0 or
3.0 would round to 3.0

I've looked at the normal rounding functions but don't see how this can
be acheived, MROUND looked promising but didn't seem to hit the nail on
the head. Do you have any ideas that can help?

Thanks very much,

CalumMurdo
Click to expand...
Hi CalumnMurdo,

Maybe you can use something like: (With your number in A1)

=ROUNDUP((2*A1),0)/2

Regards,
Bondi
 

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

rounding a number up to a certain ending digit 6
in access, round up to nearest fraction(.5) 1
rounding up to nearest specified whole number 1
Round up to nearest 25 or 50? 6
Round Function 5
Round formula 1
Divide a # into 3 #'s rounded to a whole # 9
Rounding up or down decimals to the nearest 5 2

Top