View Single Post
  #1   Report Post  
Louis Pretorius (Johannesurg, RSA)
 
Posts: n/a
Default Allocate a value to a cell from an if statement

If I have a test in cell A1:
=if(TEST,let cell C1="MESSAGE1",let cell C1="MESSAGE2")

Note the cell with the if-condition in it is not the one that will contain
either MESSAGE1 or MESSAGE2

The reason is to let the user only enter a value in C1 once a value was
entered into B1. MESSAGE1 wold be something to the extent of "First select
the type in B1". This is to overwrite the user's entry into C1.