Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using multiple IF function
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.. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using multiple IF function
Suppose the input is more than 2 years, but less than 2 years 1 month??
-- Gary''s Student - gsnu200857 "Excel Learner" wrote: 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.. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using multiple IF function
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 "Excel Learner" wrote: 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.. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using multiple IF function
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 If the input cell is A1, one way is to put this in the output cell: =(A15)+(A12)+1 If you insist on using "IF" another way is: =IF(A15,3,IF(A12,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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using multiple IF function
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. -- potter "Excel Learner" wrote: 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.. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple function is it even possible | Excel Worksheet Functions | |||
Multiple IF function (maybe OR) | Excel Worksheet Functions | |||
Multiple IF Function | Excel Worksheet Functions | |||
Multiple results from multiple criteria using IF function | Excel Discussion (Misc queries) | |||
Multiple Sheet, Multiple Criteria Look-Up Function Help | Excel Worksheet Functions |