ExcelBanter - extend formula when data is entered

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

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

- - extend formula when data is entered (https://www.excelbanter.com/excel-worksheet-functions/114435-extend-formula-when-data-entered.html)

kate

extend formula when data is entered

I want to have results shown only when I input data. At the moment the cell
formula is using 0 in place of blank cells to give the wrong answer. Help

Teethless mama

extend formula when data is entered

=IF(A1="","",your formula)

"Kate" wrote:

I want to have results shown only when I input data. At the moment the cell
formula is using 0 in place of blank cells to give the wrong answer. Help

All times are GMT +1. The time now is 05:24 AM.