Simple if

Excel Help for Simple If in Analyzing Corporate Financial Data

Forum Topic

Post Reply Login

Simple If

Rate this:

(3/5 from 1 vote)

	plz 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 sureshchinna_sb on 31 Oct 2007

Replies - Displaying 1 to 3 of 3

Order Replies By: Most Recent | Chronological | Highest Rated

	Use the AND function 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 Excel Helper on 01 Nov 2007

	Hi.. 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 barrettkellen on 22 Jan 2010

	simple if 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 irani33 on 19 May 2010

Displaying page 1 of 1

Excel templates and solutions matched for Simple if:

Solutions: Sensitivity Analysis