Thread: Ignoring #VALUE in formula calculations
View Single Post
 
Old 11-09-2018, 07:04 AM
NBVC's Avatar
NBVC NBVC is offline Windows 10 Office 2013
The Formula Guy
  
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default
IFERROR is not available in Excel 2003...




try:


=IF(ISERROR(MID(E3,2,10)+0),"",MID(E3,2,10)+0)
Reply With Quote