One way:

=IF(OR(L30="",H30=""),"",(L30/H30)*100)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"DAI via OfficeKB.com" <u29573@uwe wrote in message
news:69e8fc131a981@uwe...
Hello,

I have a simple formula (=(L30/H30)*100) which works fine, However I would
like to set up my worksheet to not give an error while "L30 and H30" have
no
values yet.

Then i can copy the formula down the column and enter the values when
required.

I know its something simple but I need a little help.

Thank You.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200611/1