IF/Then across multiple columns

[Vodo34861]

I am trying to quantify 2 values ( -1 and 1) across 5 columns into usable data. I am trying to have the end result produce a number 5 through 1 in a blank column.

So if I am thinking about this correctly then I should have

If A2 = "1" Then
    F2 = "5"
ElseIf B2 = "1" Then
    F2 = "4"
ElseIf C2 = "1" Then
    F2 = "3"
ElseIf D2 = "1" Then
    F2 = "2"
ElseIf E2 = "1" Then
    F2 = "1"
End If

Which I translated to an Nested If of

=IF(A2="1",5,IF(B2="1",4,IF(C2="1",3,IF(D2="1",2,IF(E2="1",1)))))

All I am getting with the nested code is "False"

I am going to do another nested IF function to produce for the -1 and result in 1 through 5. Then I should be able to subtract the 2 values produced to get the information I am looking for.

Any help would be appreciated.

** EDIT **

Sorry I am working in Excel 2007 for this.