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