| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how to enter a null cell value in a formula
I am trying to effect a null cell value based on a formula. For example, for
B2, I might want to have B2 be NULL if A2 is NOT NULL, otherwise use the value from B1). This might be written something like "=if(A2"",NULL,B1)". The intent is to allow the text value of A2 to extend into B2 (i.e. not wrap). Entering a "" for the TRUE action does not allow A2 to extend into B2. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| How can I write an if-then formula for 0 or less than 0 in cell t. | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
| Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
| Can you enter a formula in a cell that auto-inputs calculations a. | Excel Worksheet Functions | |||
Threaded Mode
