How to check if a cell is blank and, if so, apply a formula
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 |
How to check if a cell is blank and, if so, apply a formula
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 |
All times are GMT +1. The time now is 08:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com