View Single Post
  #1   Report Post  
Using formulas to enter NULL cell values
 
Posts: n/a
Default 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.