Thread: getting div error
View Single Post
 
Old 07-27-2011, 07:42 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
the formula is corect, be careful to your regional settings marked in red in formula, instead of ; you use ,
=IF(ISERROR((F10-D10)/D10)=TRUE;"-";(F10-D10)/D10)

look at the sample attached
Attached Files
File Type: xlsx sample.xlsx (11.8 KB, 8 views)
Reply With Quote