ExcelBanter - View Single Post

"David Biddulph" wrote in message
...
"Don Guillett" wrote in message
...
SalesAid Software

"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

you forgot the second if

=if(c10 "","0",if(ROUND(C10*1.2/38,0)<1,1,ROUND(C10*1.2/38,0))

... and you forgot the first =
:-)

second actually <eb :-)