Home > Forum Home > Analyzing Corporate Financial Data > Simple if Share

Simple if

Excel Help for Simple If in Analyzing Corporate Financial Data


Forum TopicPost Reply Login

Simple If

Rate this:
(3/5 from 1 vote)
Confusedplz find the below function

=if(a1=1,"ram",if(a1=2,"sita",if(a1=3,"ravi","kiran")))


But i need only one if to check all the above condition. Plz do favour
 hemanth
 Posted by on
 
Replies - Displaying 1 to 3 of 3Order Replies By: Most Recent | Chronological | Highest Rated
Happy
Rate this:
(3/5 from 1 vote)
You can use the AND function to ensure all criteria are met:

=IF(AND(A1=1,A2=2),"YES","NO")

Although it looks like you need a conditional whereby any criteria is met, therefore you can do the same thing with an OR function.
 Excel Business Forums Administrator
 Posted by on
Confused
Rate this:
(3/5 from 1 vote)
I think the if condition you have given is not correct that is it contains some syntax error.



[http://www.expertverdict.com/webapp/wcs/stores/servlet/MCategory_20051_23737_-1_11051]
 Posted by on
Confused
Rate this:
(3/5 from 1 vote)
yes I do think it is correct, there seems an syntax error in that syntax, please correct it check again.


 online digital printing uk
 Posted by on
 Displaying page 1 of 1 

Excel templates and solutions matched for Simple if:

Solutions: Sensitivity Analysis