View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DAI via OfficeKB.com DAI via OfficeKB.com is offline
external usenet poster
 
Posts: 6
Default How To Stop #Div

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