How do i write an If function where if a cell has a certain text in it, it would return a value to onather cell.
For instance:
If cell B1 has "red" in it the cell B4 must be "6"
If cell B1 has 'blue" in it, then cell B4 must be "7"
and so on with certain text returning a certain value?
Please can you help me?
Bookmarks