If condition

Excel Help for if condition in Analyzing Corporate Financial Data

Find Excel Solutions

Search the Forums:
	Search
Recent Activity:
Delete Cell Items In Spreadsheet
Importing Data From Pdf Files
New Portfolio Optimization Template Version
Financial Market Data Feed
Run Time Error 1004
Data Downloader Crashes Excel

Follow Business Spreadsheets On:

Home > Forum Home > Analyzing Corporate Financial Data > if condition

Forum Topic

Reply Login

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

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

Find Excel templates
and add-ins in the
Excel Business Solutions Directory