gogs4795

Hi, I hope that someone can help me with this problem. googling didn't show me any solution...
here is my problem:

numbers in one column need to be rounded to the nearest half decimal, with next conditions(ill took number 704,00 for example):
- if last two decimals are < 0,25 then my number has to be 704.00
- if last two decimals are >0,25<0,75 then my number has to be 704.50
- and finally if last two decimals are >0,75 then my number has to be 705.00

I tried with IF, CEILING, INT and ROUND functions but i didn't made it work with three options, that i need. I only made it work if i use only two options.

here is attachment with example what i wanted to do:

Attached Files

Book1.zip (1.9 KB, 0 views)

Elkar

Try this:

=ROUND(A1/0.5,0)*0.5

HTH
Elkar