Microsoft Office Forums - View Single Post - Indirect results returning 0 instead of blank

Thread: Indirect results returning 0 instead of blank

View Single Post

Old

04-30-2018, 01:03 PM

jennyyoung jennyyoung is offline

jennyyoung is offline

jennyyoung uses Windows 7 32bit

Windows 7 32bit jennyyoung uses Office 2010 32bit

jennyyoung uses Office 2010 32bit

Office 2010 32bit

Novice

The original poster

Join Date: Apr 2018

Posts: 15

jennyyoung is on a distinguished road

Default

Indirect results returning 0 instead of blank

I am using an indirect formula and I need blank cells to remain blank instead of 0.

this i the formula
='\\177.177.1.14\Sales\Order Status 2018\[Jason''s Orders.xlsx]Jasons Customers'!A79

Reply With Quote