# Multiple conditions with single if

## Excel Help for Multiple Conditions With Single If in Analyzing Corporate Financial Data

### Multiple Conditions With Single If

Rate this:
(3/5 from 1 vote) plz gothrough with the following if conditionif(condition1,"trueblock",if(second condition,"true block",if(third condition,"true block","false block")))but i need only one if two check above three conditionsexample:if(a1=1,"one",if(a1=2,"two",if(a1=3,"three","four"))) hemanth Posted by sureshchinna_sb on 19 Oct 2007
 Replies - Displaying 1 to 1 of 1 Order Replies By: Most Recent | Chronological | Highest Rated Rate this:
(3/5 from 1 vote)
you can try choose instead of nested ifs

 1 =CHOOSE(A1,"one","two","three","four") 2 =CHOOSE(A2,"one","two","three","four") 3 =CHOOSE(A3,"one","two","three","four") 4 =CHOOSE(A4,"one","two","three","four")

write the formula in first row n then drag it
PD
Posted by on
 Displaying page 1 of 1

 Find relevant Excel templates and add-ins for multiple conditions with single if in the Excel Business Solutions Directory