Can I show a blank if a cell reference is missing?

jez251

New Member
Joined
Mar 4, 2015
Messages
10
I have a worksheet that is making cell references to a few HTML files. In most cases I will have all of the HTML files in a designated folder, but sometimes I may be missing an HTML file. In these cases I would want the cells in my worksheet o not give me the values when the HTML file was present, instead I would want it to show as blanks or 0.

For instance, I have language columns in a worksheet and for each language if the corresponding HTML files exist, I want the cell references to populate accordingly. But if a certain language's HTML file is missing, instead of seeing the previous value of the cell reference (when that language's HTML was present), I would want to see either a blank or 0. These values are linked to other cells within the workbook and I don't want to show old data.

By the way, having a cell reference to an HTML file works!

Any ideas would be appreciated.

thanks,
Jaime
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Forum statistics

Threads
1,223,908
Messages
6,175,305
Members
452,633
Latest member
DougMo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top