In a workbook, have a data entry sheet that is protected except for fields
for answers. These fields (shaded yellow) are formatted as accounting. The
yellow fields on the Data Entry worksheet populate other cells in the Webinar
Cost Calculator and Webinar ROI Calculator worksheets. If a cell on the Data
Entry screen is blank, I want it to return a blank, not a 0 or a -, which
it's currently doing. Can excel format the result when there is no data to
return a blank?
Bookmarks