# If condition

## Excel Help for if condition in Analyzing Corporate Financial Data

 Find Excel Solutions

 if condition Rate this: (3/5 from 1 vote)
 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 on
 Replies - Displaying 1 to 1 of 1 Order Replies By: Most Recent | Chronological | Highest Rated
 Rate this: (3/5 from 1 vote) you can use a function. see this url http://www.ozgrid.com/VBA/CurrencyToWords.htmcopy 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 SelectEnd Function [/code] Posted by [email protected] on 05-Jan-2009
 Displaying page 1 of 1

 Find relevant Excel templates and add-ins for if condition in the Excel Business Solutions Directory