| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MORE THAN ONE FUNCTION IN THE SAME CELL
How I can write this function for one cell
=IF(O9<-2%;1); IF(-1%<O9<-2%;2); IF(-1%<O9<2%;3); IF(2%<O9<6%;4); IF(O96%;5) More in detail I have to compare a value with 5 criteria and put the relevant number from 1 to 5 Thank you |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
MORE THAN ONE FUNCTION IN THE SAME CELL
Hi
Something like this should do the trick: =IF(O9<-0.02,1,IF(O9<-0.01,2,IF(O9<2,3,IF(O9<0.06,4,5)))) Andy. "Papadopoulos Panagiotis" <Papadopoulos wrote in message ... How I can write this function for one cell =IF(O9<-2%;1); IF(-1%<O9<-2%;2); IF(-1%<O9<2%;3); IF(2%<O9<6%;4); IF(O96%;5) More in detail I have to compare a value with 5 criteria and put the relevant number from 1 to 5 Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function that Returns address of that cell? | Excel Worksheet Functions | |||
| Excel 2000: sum function automated? | Excel Discussion (Misc queries) | |||
| Change Cell properties by Function | Excel Worksheet Functions | |||
| Reading Cell Function??? | Excel Worksheet Functions | |||
| IF Function to test formula in a cell | Excel Worksheet Functions | |||
Linear Mode
