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