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

Thread: Ignoring #VALUE in formula calculations

View Single Post

Old

11-09-2018, 06:58 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

The value I am extracting is between M1 and M12, so 10 is OTT, M value is selected from a drop down list, so I don't know if that complicates matters. I tried the IFERROR formula and now returning #NAME.

Thanks

Nick

Reply With Quote