If condition

Excel Help for If Condition in Analyzing Corporate Financial Data

Find Excel Solutions


Search Forums:
Recent Activity:
Web Query
Vba Save To Skydrive
Auto-timing Not Working Properly
"runtime Error 13" And "runtime Error -2147483640" Excel 2011 Mac
Portfolio Performance Monitoring And Valuation
Importing Data From Pdf Files




Follow Business Spreadsheets On:
 
Forum TopicReply Login

If Condition

Rate this:
(3/5 from 1 vote)
ConfusedExcel Spreadsheet:
 ABC
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 1Order Replies By: Most Recent | Chronological | Highest Rated
Confused
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 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 |