If condition

Excel Help for If Condition in Analyzing Corporate Financial Data

Find Excel Solutions


Search Forums:
Recent Activity:
Importing Data From Pdf Files
Need Help With Formulas And Fixing This Spreadsheet
Wanting To Calculate All Hours Worked On A Project With Timesheets
Simple Formulae For Creating Complex Interactive Dashboards In Excel
What Is Microsoft Project Gantt Chart Used For?
Check Pdf Files For Text From Excel File.




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 |