Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting - check for blank cell | Excel Discussion (Misc queries) | |||
How to... apply the same formula to every cell? | Excel Discussion (Misc queries) | |||
How to check for blank cells with formula | Excel Discussion (Misc queries) | |||
check to see if a cell is blank if not populate adjacent cell wit. | Excel Discussion (Misc queries) | |||
How can I check a cell for current date and insert it if blank? | New Users to Excel |