"billy_bags" wrote in message
...
=IF(ROUND(C10*1.2/38,0)<1,"1",ROUND(C10*1.2/38,0))

However, if cell c10 has no figure in it at all I want it to show "0"

I have tried
=if(c10 "","0",ROUND(C10*1.2/38,0)<1,"1",ROUND(C10*1.2/38,0))
but the formula error box appears
Can some kind soul enlighten me and
Is there a neater way that I can express this formula

Do you mean:
=IF(C10="","0",IF(ROUND(C10*1.2/38,0)<1,"1",ROUND(C10*1.2/38,0))) ?
--
David Biddulph