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.. |
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 |