How to check if a cell is blank and, if so, apply a formula

[Arnold]

Hi Programmers,

I'm trying build an Excel app. that is user friendly. In a column (C),
a user may enter a nickname. If there is no nickname, then the value
that was in the first name field (B) is auto copied to the nickname
field (such as =B2).

If a user enters a nickname, then deletes the nickname, how can the
underlying formula (=B2) be reapplyed to the cell automatically? Also,
I'm concerned about if the user manually enters a nickname in the last
record, then adds another row manually or with a macro that copies
formulas and formatting to the new row--any formula overwritten would
not be included.

Just curious; thanks,

Arnold

 

[Arnold]

Hi Dave,

This is a seemingly simple issue, but not? If a user enters a nickname
in C2 (deleting the underlying formula =B2), then deletes the nickname,
the formula =B2 needs to be re-applied to C2. Adding an additional
scratch column won't help because the C2 cell will still not have the
formula. Is there a way to store a relative formula, and then apply it
if a cell is blank or null?

Thanks again,

Arnold