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 condition if(condition1,"trueblock",if(second condition,"true block",if(third condition,"true block","false block"))) but i need only one if two check above three conditions example: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

	avoiding nested ifs 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 pooja_dubey12 on 31 Mar 2008

Displaying page 1 of 1