Thread: getting div error
View Single Post
 
Old 07-26-2011, 06:28 AM
Catalin.B Catalin.B is offline Windows Vista Office 2007
Expert
  
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default
Normally, you dont need SUM in this formula =(F11-D11)/D11
To remove the error:
Try this: =IF(ISERR((F11-D11)/D11*100)=TRUE;"-";(F11-D11)/D11*100)
Reply With Quote