Microsoft Office Forums - View Single Post - Ignoring #VALUE in formula calculations

Thread: Ignoring #VALUE in formula calculations

View Single Post

Old

11-09-2018, 04:13 AM

NickFazer

NickFazer is offline

NickFazer uses Windows 7 64bit

Windows 7 64bit NickFazer uses Office 2003

NickFazer uses Office 2003

Office 2003

Novice

The original poster

Join Date: Sep 2018

Posts: 8

NickFazer is on a distinguished road

Default

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

Reply With Quote