Home > Forum Home > Analyzing Corporate Financial Data > multiple conditions with single if Share

Multiple conditions with single if

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


Forum TopicPost Reply Login

Multiple Conditions With Single If

Rate this:
(3/5 from 1 vote)
Confusedplz 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 on
 
Replies - Displaying 1 to 1 of 1Order Replies By: Most Recent | Chronological | Highest Rated
Confused
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