Floor and ceiling functions

Hi all

I wondered if someone could help me. I was a function which combined the ceiling and floor functions.

Working on 2.5 floor or ceiling value, If the value in a cell is for example 25.5 I would like it to round it down to 25 and conversely, if it is above the midpoint between 25 and 27.5 (i.e. 26.25), then I would like it round it up. I would like this to work for all values though through 2.5 interval values.

Hope this makes sense. The value in a cell is often determined by a formula. The current one I am looking at is as follows;

= t4 - g14

this returns the value 27.175. I want this to round up to 27.5. If however the value had been 26.124, then I would like this to round down to 25.

Any help would be much appreciated

Cheers

David

its ok I've worked it out using the mround function. Seems to be working

thanks

thanks daddylonglegs....

great minds!