| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
use more than 7 if condition in a cell
Hi,
I'm getting problem to use more than 7 if condition in a cell in excel 2003, in there I can input only 7 if condition like =if(a1=0,"0",if(a1<100,"1",if(a1<200,"2",if(a1<300 ,"3",if(a1<400,"4",if(a1<500,"5",if(a1<600,"6",if( a1<700,"7","Out of Range"))))))) but I want more condition to be input like =if(a1=0,"0",if(a1<100,"1",if(a1<200,"2",if(a1<300 ,"3",if(a1<400,"4",if(a1<500,"5",if(a1<600,"6",if( a1<700,"7",if(a1<800,"8",if(a1<900,"9",......to be continued the end of require,"Out of Range")))))))))))))..... is there any solution for the above problem. Thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lookup with multiple condition, but one condition to satisfy is en | Excel Worksheet Functions | |||
| Moving to cell based on condition of another cell | Excel Discussion (Misc queries) | |||
| Hide cell values based on a condition in another cell | Excel Worksheet Functions | |||
| if a condition is met I want an x in a cell | Excel Worksheet Functions | |||
| I want to fill the cell color based upon the other cell condition | Excel Discussion (Misc queries) | |||
Threaded Mode
