Else if in excel?

[munkifisht]

I was wondering how you can create an else if statment in excel?

I have a cell that will be filled with one of ten options, for convienence lets say they are 0-9. Depending in the value of the cell, I want to fill another with a value, say a letter. Also, if another nominated cell is filled, I want this one to override the second cell and for it to generate a different unique value in tyhe target cell.

Lets say
if
a1-blank
a2-1
then
a3-a
if
a1-blank
a2-4
a3-j
but if
a1-10
a2-any 1-9
a3-will look at a1 and give "u"

 

[Zack Barresse]

You can continue your logic, just plug it into the correct syntax ...

if range("a1") = vbNullString then
if range("a2") = 1 then
    range("a3") = "a"
elseif range("a2") = 4 then
    range("a3") = "j"
end if
'...
end if

You can continue on like this. It's somewhat hard to follow what you are looking at, and it would seem (right off hand) that their may be an easier way, it just depends on what your data structure is.

 

[munkifisht]

Sorry bout my language bk there, Aight!!! I' is tryin nowz to keepz it real fo da homz! Ahhhh Yea!

Thanks man, how would I make that into a function in excel? I have never done that before?

 

[Zack Barresse]

Well, you could use the IF function, but you can only nest 7 of them. An example would look like this ...

(assumed to be in A3)
=IF(A1="",IF(A2=1,"a",IF(A2=2,"J","else..")))