Thread: show 0.00 if referenced cell is empty
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mark Lincoln Mark Lincoln is offline
external usenet poster
  
Posts: 227
Default show 0.00 if referenced cell is empty
On Jun 26, 2:07 pm, "David D" wrote:
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

=IF(ISNUMBER(B9),2240/(B9*7.2),0)

Mark Lincoln

Reply With QuoteReply With Quote