An if statement didplays a specific output based on the value of a particular cell.
For example, say you want to dislay the word "No" everytime the value in any of the cells in column A say "Clean Version" or otherwise display the word "Yes".
The formula below is an example of the above query:
=IF(A2="Clean Version","No","Yes")
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 word "No" everytime the value in any of the cells in column A say "Clean Version" or otherwise display the word "Yes".
The formula below is an example of the above query:
=IF(A2="Clean Version","No","Yes")
Note: quotes are always used for text or alpha numeric data. Do not include quotes for number values.
0 comments:
Post a Comment