An if statement didplays a specific output based on the value of a particular cell. An else if statement displays more than one output...So it is not giving a yes or no answer, but several possible answers.
For example, say you want to dislay the word child for the age less than 18 and the word working adult for ages less than 65 and the word retired for ages equal to and over 65. Let us say column A has the range of ages.
The formula below is an example of the above query:
=IF(A2<18,"Child",IF(A2<65,"Working Adult","Retired"))
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 child for the age less than 18 and the word working adult for ages less than 65 and the word retired for ages equal to and over 65. Let us say column A has the range of ages.
The formula below is an example of the above query:
=IF(A2<18,"Child",IF(A2<65,"Working Adult","Retired"))
Note: quotes are always used for text or alpha numeric data. Do not include quotes for number values.
0 comments:
Post a Comment