Ignoring #VALUE in formula calculations

		Microsoft Office Forums > Microsoft Excel > Excel
Ignoring #VALUE in formula calculations

11-09-2018, 07:04 AM

NBVC

Windows 10 Ignoring #VALUE in formula calculations

Office 2013

The Formula Guy

Join Date: Mar 2012

Location: Mississauga, CANADA

Posts: 215

IFERROR is not available in Excel 2003...

try:

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Orphan/widow control ignoring single line	seanspotatobusiness	Word	8	07-17-2018 03:46 PM
Any way to ignore neighboring cell while ignoring blank cells in SUMPRODUCT?	dominicrudin	Excel	1	01-08-2017 10:38 AM
Calculations	etobias	Word	2	11-09-2016 10:14 AM
View by date ignoring folders?	adamgram	Outlook	0	09-12-2013 07:22 AM
Merge Field Ignoring Zeros	Welshie82	Mail Merge	2	05-04-2012 01:56 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:50 PM.