I have a graph that is automated to update based on entries on a separate workbook using a hyperlink. I need to add an 'if' statement formula to each cell that returns a '0.0%' because the data has not yet been entered on the referenced workbook so that it returns a blank instead of a '0.0%'. The graph shows production numbers and since it's automated for future dates, my boss thinks I'm forecasting zeros.
I tried =IF(A1=0,"",referenced workbook), but that still returned '0.0%'. I tried =IF(A1=0,"",FALSE) and =IF(A1=0,'N/A') nothing has worked so far. I still get the '0.0%'.
I'd like to maintain the automation, but return a blank cell when the hyperlink returns '0.0%' so that the graph does not plot the zeros.