The IF function has three parts to it... the logical test, the true result
and the false result. The false result part is equivalent to your ELSE
attempt. Try writing your formula this way...

=IF(C6<8,C6,MROUND(C6,0.25))

--
Rick (MVP - Excel)


"Eidink" wrote in message
...
Is it possible to use this type of syntax in Excel - eg
IF(c6<8,c6)ELSE MROUND(c6,0.25) What am I doing incorrectly?
Thanks
Eidin