Thread: show 0.00 if referenced cell is empty
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David D David D is offline
external usenet poster
  
Posts: 5
Default show 0.00 if referenced cell is empty
this formula =2240/(B9*7.2) will show an error until something is entered
into cell B9

I would like it to be 0.00 until B9 is populated, how is this done?

Thanks, David


Reply With QuoteReply With Quote