Thread: getting div error
View Single Post
 
Old 07-27-2011, 11:25 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
Sorry Kimberly, but this formula does not calculate the increase

=IFERROR((F10-D10)/F10,"-")

I guess you intended =IFERROR((F10-D10)/D10,"-")
But maybe i am wrong , anyway, there are more than one solution to a problem, another could be: IFERROR(F1/D1-1,"-")
Reply With Quote