I want to make the text of some cells be replaced based on a selection or on the value of another cell.
- I can make the choice for a cell between X and Y (for data validation function).
- Based on the choice I made the value of certain cell will be replaced.
=IF(C11 = "X";"Y";"Text")
Published by aakai1056
Latest update on April 17, 2013 at 10:32 AM by deri58.