Excel - a question about rounding figures up

[mankymummymoo]

So... I have a calculation I am making which totals in cell C40. I want to round it up to the nearest .25 (ie so that 1.13 rounds up to 1.25 etc).

I have managed to put this code in to make it round up to .50

=IF(C40-INT(C40)0.5),ROUNDUP(C40,0))

BUT... cannot figure out how to make it do it to .25.

Any ideas please?

I can;t make your formula work

I think you need Ceiling

=ceiling(c40,0.25)

Absolute genius !

I am not worthy [bows in gratitude]

Thank you !