ExcelBanter - problem with blank cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - problem with blank cell (https://www.excelbanter.com/excel-worksheet-functions/81047-problem-blank-cell.html)

chiuinggum

problem with blank cell

I am facing problems with cell that has not been fill. In cell C1 there is a
formula that reference to B1. But before B1 is fill, C1 will displayed.

Ardus Petus

problem with blank cell

In C1, enter:
=IF(B1="","",Your_formula)

HTH
--
AP

"chiuinggum" a écrit dans le message
de ...
I am facing problems with cell that has not been fill. In cell C1 there is
a
formula that reference to B1. But before B1 is fill, C1 will displayed.

All times are GMT +1. The time now is 09:58 AM.