If condition

Excel Help for If Condition in Analyzing Corporate Financial Data

Forum Topic

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