Ignoring #VALUE in formula calculations

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

FAQ

Thread Tools

Display Modes

11-09-2018, 04:13 AM

NickFazer

Windows 7 64bit Ignoring #VALUE in formula calculations

Office 2003

Novice

Join Date: Sep 2018

Posts: 8

Hi Marcia

Thank you for your reply, still having an issue adding the IFERROR function to work with the formula below

=MID(E3,2,10)+0

I have tried =IFERROR((MID(E3,2,10)+0),"")

Any ideas why this is wrong?

Thanks

Nick

« Previous Thread | Next Thread »

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:42 AM.