| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell addressing using the content of another cell. | Excel Worksheet Functions | |||
| IF Statement that's conditional on multiple IF Stmts in other cell | Excel Worksheet Functions | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| Search for a specific character in a cell in an if statement | Excel Worksheet Functions | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Threaded Mode
