If condition

Excel Help for If Condition in Analyzing Corporate Financial Data

Find Excel Solutions

Search Forums:
Recent Activity:
Importing Data From Pdf Files
Same Output By Varying The Target Returns
Web Query
Vba Save To Skydrive
Auto-timing Not Working Properly
"runtime Error 13" And "runtime Error -2147483640" Excel 2011 Mac

Follow Business Spreadsheets On:
Forum TopicReply Login

If Condition

Rate this:
(3/5 from 1 vote)
ConfusedExcel Spreadsheet:
1 1 =if(a1=1,"one",if(a1=2,"two",if(a1=3,"three","four"))) 

i need one if to check all the above conditions
 Posted by on
Replies - Displaying 1 to 1 of 1Order Replies By: Most Recent | Chronological | Highest Rated
Rate this:
(3/5 from 1 vote)
you can use a function. see this url

copy paste this function preferabley in personal.xls file 

suppose A1 has 1 or 2 or 3 etc type in B1
do you get what you want. 

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

 Posted by on
 Displaying page 1 of 1 

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


Find Excel templates
and add-ins in the
Excel Business Solutions Directory
  © 2014 Business Spreadsheets. All Rights Reserved. Legal |