Good morning,
I have a dashboard that refers to multiple workbooks and returns values into my dashboard. I have a cell that refers to a separate workbook sheet that has the value of #DIV/0! and returns on my dashboard as the same.
My cell refers to ='G:\PMO_Status_NEW\[Business_Solutions.xlsm]Client'!$B$44
How can i get my cell to not display #DIV/0! instead display "none"
I tried adding IF statment - didnt work
Any help would be appreciated.
thanks
I have a dashboard that refers to multiple workbooks and returns values into my dashboard. I have a cell that refers to a separate workbook sheet that has the value of #DIV/0! and returns on my dashboard as the same.
My cell refers to ='G:\PMO_Status_NEW\[Business_Solutions.xlsm]Client'!$B$44
How can i get my cell to not display #DIV/0! instead display "none"
I tried adding IF statment - didnt work
Any help would be appreciated.
thanks