Thread: #DIV/0! Errors
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK
 
Posts: n/a
Default #DIV/0! Errors

P6 must be zero or blank. Try this to avoid the error:

=IF(P6=0,0,(P6/100*55-P30)/(P6/100*55)*100)

Hope this helps.

Pete