Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
i want to give more than 6 condition by using if statement
when i am given the below condition it is given me an error, please help me
how to do it for the students details. =IF(C4<35,"Fail",IF(D4<35,"Fail",IF(E4<35,"Fail",I F(F4<35,"Fail",IF(G4<35,"Fail",IF(H4<35,"Fail",if( j4<45,"Pass",if(j4<60,"Second Class",if(j4<75,"First Class","Distinction"))))))))) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
i want to give more than 6 condition by using if statement
On Sat, 14 May 2005 10:16:04 -0700, Sushil
wrote: when i am given the below condition it is given me an error, please help me how to do it for the students details. =IF(C4<35,"Fail",IF(D4<35,"Fail",IF(E4<35,"Fail", IF(F4<35,"Fail",IF(G4<35,"Fail",IF(H4<35,"Fail",if (j4<45,"Pass",if(j4<60,"Second Class",if(j4<75,"First Class","Distinction"))))))))) A different approach, using VLOOKUP, would work better. If I understand your formula, you are computing: 1. If any cell in the range C4:H4 is < 35, then "Fail". 2. Otherwise, compute a response based on the contents of J4. That being the case, the following formula will accomplish that: =IF(COUNTIF(C4:H4,"<35"),"Fail",VLOOKUP(J4, {35,"Pass";45,"Second Class";60,"First Class";75,"Distinction"},2)) The array constant can also be placed in a two column vertical table, and referred to by a Name or Cell Reference (e.g. X1:Y4): 35 Pass 45 Second Class 60 First Class 75 Distinction --ron |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
i want to give more than 6 condition by using if statement
I think you have exceeded the IF statement speed limit! Strictly as
a footnote, there is a limited number of IF statements that you can string together and when you exceed that limit (which is nowhere near your logic limit), they just don't work. A working knowledge of logic statements can accomplish some amazing tasks; Ron reminds us, however, that there are much more elegant solutions. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
To give back ground colour for entire row on certain condition | Excel Discussion (Misc queries) | |||
Condition Statement | Excel Discussion (Misc queries) | |||
Statement to give focus to a specific control on a UserForm? | Excel Programming | |||
Condition Statement Help?? | Excel Programming | |||
Condition Statement | Excel Programming |