If condition

Excel Help for If Condition in Analyzing Corporate Financial Data

If Condition

Rate this: (3/5 from 1 vote)

	Excel Spreadsheet:   A B C 1  1  =if(a1=1,"one",if(a1=2,"two",if(a1=3,"three","four")))   2       3       i need one if to check all the above conditions
	hemanth
	Posted by sureshchinna_sb on 19 Oct 2007

Replies - Displaying 1 to 1 of 1

Order Replies By: Most Recent | Chronological | Highest Rated

if condition Rate this: (3/5 from 1 vote) you can use a function. see this url http://www.ozgrid.com/VBA/CurrencyToWords.htm copy paste this function preferabley in personal.xls file  suppose A1 has 1 or 2 or 3 etc type in B1 =convertdigit(A1) do you get what you want.   [/code] Private Function ConvertDigit(ByVal MyDigit) Select Case Val(MyDigit)             Case 1: ConvertDigit = "One"             Case 2: ConvertDigit = "Two"             Case 3: ConvertDigit = "Three"             Case 4: ConvertDigit = "Four"             Case 5: ConvertDigit = "Five"             Case 6: ConvertDigit = "Six"             Case 7: ConvertDigit = "Seven"             Case 8: ConvertDigit = "Eight"             Case 9: ConvertDigit = "Nine"             Case Else: ConvertDigit = ""          End Select End Function  [/code]

Posted by [email protected] on 05 Jan 2009

Displaying page 1 of 1