If you want to round monetary figures to the nearest 50p or the nearest 25p you can use the MROUND function which takes a number and rounds it to the desired multiple.
The syntax for this function is MROUND(Number,multiple). So to round to the nearest 50p:
=MROUND(C2,0.5)
And to round to the nearest 25p:
=MROUND(C2,0.25)
Find out more about our Microsoft Excel training London, UK.
Find out more about our Microsoft Excel training Wiltshire, Hampshire, Dorset.