Let us say column A has you prices and you want to add 25% between 10 and 19, add 35% between 20 and 29 and so on. The best thing to do is an else if statement like this:
if(a2
Read More..
if(a2
Showing posts with label Excel else if statement. Show all posts
Showing posts with label Excel else if statement. Show all posts
Sunday, November 18, 2012
Sunday, October 28, 2012
Using IF Statements in MS Excel
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.
Subscribe to:
Posts (Atom)