Hello All,

I am trying to make a fillable worksheet for internal use within our office.  I have a cell (B3) that I want to hold placeholder text that tells the user what to put into it.  I’m hoping I can make a formula to fill the cell with a text prompt when left blank.  In essence this is the “If/Then” statement:

IF REFERENCED CELL IS BLANK THEN FILL REFERENCED CELL WITH “NAME”

My thinking was to write an =IF combined with =ISBLANK formula in a separate cell (i.e. G30) that references B3, and then fills B3 with “Name” if it is blank.  The formula works but it understandable is filling G30) with “Name”.  Does anyone have any ideas of how I can have the formula fill the cell it is referencing?

Additionally, I’m also anticipating a logic error with this.  If I have a formula checking to see if a cell is blank, and then filling that cell, it won’t be blank.  Is that a problem?

​Hello All, I am trying to make a fillable worksheet for internal use within our office.  I have a cell (B3) that I want to hold placeholder text that tells the user what to put into it.  I’m hoping I can make a formula to fill the cell with a text prompt when left blank.  In essence this is the “If/Then” statement: IF REFERENCED CELL IS BLANK THEN FILL REFERENCED CELL WITH “NAME” My thinking was to write an =IF combined with =ISBLANK formula in a separate cell (i.e. G30) that references B3, and then fills B3 with “Name” if it is blank.  The formula works but it understandable is filling G30) with “Name”.  Does anyone have any ideas of how I can have the formula fill the cell it is referencing? Additionally, I’m also anticipating a logic error with this.  If I have a formula checking to see if a cell is blank, and then filling that cell, it won’t be blank.  Is that a problem?  Read More

​