Thread: Fix Simple #Div/0! error
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bondi
 
Posts: n/a
Default Fix Simple #Div/0! error
Hi,

Try

=if(iserror((E7+F7)/$J$12*$I$5),"",(E7+F7)/$J$12*$I$5)

Regards,
Bondi

Reply With QuoteReply With Quote