[Microsoft] Multiple IF Condition in one Cell
Posted by admin on July 28th, 2010
Normally IF function in Microsoft excel by default you will see only for one statement true and false.
If the statement is match, then the condition is TRUE.
If the statement is not match, then the condition is FALSE.
TRUE or FALSE can be value, formula, or text.
Problem : What if the we need more option/conditions…
Let say, below my excel file.
I need to manipulate my cell on E23 with IF.
The condition has to be :
1. If the D23 is similar to D16, then E23 will show text “128 Kbps”
2. If the D23 is similar to E16, then E23 will show text “256 Kbps”
3. If the D23 is similar to F16, then E23 will show text “392 Kbps”
4. If the D23 is similar to G16, then E23 will show text “512 Kbps”
5. If the D23 is similar to H16, then E23 will show text “1024 Kbps”
2. If the D23 is similar to I16, then E23 will show text “2048 Kbps”
So the IF function would be :
=IF(D23=D16,”128 Kbps”,IF(D23=E16,”256 Kbps”, IF(D23=F16,”392 Kbps”, IF(D23=G16,”512 Kbps”, IF(D23=H16,”1024 Kbps”, IF(D23=I16,”2048 Kbps”))))))
I don’t have any idea, how the maximum if function can be extend that way.
Lately I Found, “128 Kbps” we can replace with D14 without ” ” etc…
a. rahman isnaini r.sutan