An if search statement diplays a specific output based on a value that is embedded within a text string that contains other values.
For example, say you want to dislay the number 1.78 everytime the value in any of the cells in column A contains the value of 16:9 or otherwise display the word "Check Material". Let's also say an example text in cell A2 is "625 PAL - 16:9 WIDESCREEN"
The formula below is an example answer to the above query:
=IF(NOT(ISERROR(SEARCH("16:9",A2,1),1.78,"Check Material")
Note: quotes are always used for text or alpha numeric data. Do not include quotes for number values.
For example, say you want to dislay the number 1.78 everytime the value in any of the cells in column A contains the value of 16:9 or otherwise display the word "Check Material". Let's also say an example text in cell A2 is "625 PAL - 16:9 WIDESCREEN"
The formula below is an example answer to the above query:
=IF(NOT(ISERROR(SEARCH("16:9",A2,1),1.78,"Check Material")
Note: quotes are always used for text or alpha numeric data. Do not include quotes for number values.
0 comments:
Post a Comment