rounding up or down in EXCEL

[jyeh74]

I was wondering if there is a formula to round UP to the nearest 0.5 in excel. Also need a formula to round DOWN to the nearest 0.5 in excel.

I searched and found =mround(cell,0.5), but this formula rounds up or down to the closest 0.5. For example, if I type 1.24, it rounds it to 1. If I type 1.25, it rounds it to 1.5
On certain cells, I want it to round UP. For example, 1.1 = 1.5 and 1.51 = 2
On certain cells, I want it to round DOWN. For example, 1.1 = 1 and 1.99 = 1.5

Is this possible or is it being too specific?

[redwudz]

There's probably a way, but I just use two decimal places (Or more depending on the precision I want.) and save rounding down any further to the last math operation. That keeps the rounding induced errors to a minimum. I run most critical calculations with four to six decimal places, then change the final output to two decimal places most times for ease in reading.

[jyeh74]

yah, certain cells i want to round up to the nearest 0.5 only and certain i want to round down to the nearest 0.5

[guns1inger]

http://www.ozgrid.com/Excel/excel-rounding.htm might help

or this

http://www.digdb.com/excel_add_ins/round_up_down_rounding/

[jyeh74]

guns1inger,

I went to your links, but read my above posts. Is my request too specific? 1.2 rounds to 1, (using MROUND) instead of rounding up to 1.5 (in cases where I want to round to the nearest 0.5)
Roundup and Rounddown formulas dont give it to the nearest 0.5

[guns1inger]

Because your requirements don't follow standard mathematical principles for rounding, you will have to write either a formula or some VBA to do this. RoundUP and RoundDown plus some basic evaluation should get you close. Floor might also be of use.

[träskmannen]

Like Guns1inger wrote:

=floor(cell;0,5) will round down to the nearest multiple of 0,5.
=ceiling (cell;0,5) will round up to the nearest multiple of 0,5.

[jyeh74]

thats what i was looking for, thanks a lot guys! i didnt even know they had that function in excel to that specificity.