# Using multiple IF function

E

#### Excel Learner

I am trying to create a survey result sheet in which there are 2 cells
Cell 1 : Input - Any number as described below
Cell 2 : Output : Gives out value of 1,2 or 3 in accordance with input.
Less than 2 years old : 1 pt
2yrs 1 month to 5 years : 2 pts
Greater than 5 years 1 month : 3 pts
The above 3 are the conditions.
P.S. : This is for one cell only,not multiple cells
Eg : If I enter 3 in inout cell it must say 2 in output cell.
Plz help!!!!
I dont know how to write Macro programs so any help in solving this for me
would be greatly appreciated.
Thank you..

G

#### Gary''s Student

Suppose the input is more than 2 years, but less than 2 years 1 month??

K

#### Kris

The way I would do it would be using a Vlookup and an IF statement. You
would create a worksheet where you would have one column called Input and
another called Output. On the Input side type in the values someone would
enter. On the output side put the value you want returned.

Then on the cell you want the value shown, you would use an =if(vlookup)
formula to return the correct result.

I do not have your exact info, but you can get what you need on this site.

http://www.contextures.com/xlFunctions02.html

P

#### pomegranate-man

I am trying to create a survey result sheet in which there are 2 cells
Cell 1 : Input - Any number as described below
Cell 2 : Output : Gives out value of 1,2 or 3 in accordance with
input.

If the input cell is A1, one way is to put this in the output cell:
=(A1>5)+(A1>2)+1

If you insist on using "IF" another way is:
=IF(A1>5,3,IF(A1>2,2,1))

As others have noticed, the conditions in the original post have one-month
gaps (after 2 yrs an after 5 yrs). The above formulas assume that the gaps
really weren't intended. If that's wrong, modify accordingly.

P

#### potter

I'm a learner too...couldn't you just have one column wiht the rating for
each result? eg just use the 1,2,3 points....you'll know if you see 1 that
the survey response was less than 2 years.