If Target.Address = Range("NamedRange").Address Then - is a conflict with another

Hi All,

I have a little problem, and I am unsure if I am doing this right.
I have a couple of If statements that seem to conflict with each other. Appreciate any help

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Address = Range("metres").Address Then
    Range("feet").Formula = "="metres"*3.28083"
    Range("yards").Formula = "="metres"*1.09361"
End If

If Target.Address = Range("yards").Address Then
    Range("metres").Formula = "="yards"*0.9144"
    Range("feet").Formula = "="yards"*3"
End If

If Target.Address = Range("feet").Address Then
    Range("metres").Formula = "="feet"*0.3048"
    Range("yards").Formula = "="feet"*0.3333333"
End If

End Sub

So basically, if I enter one value, the other two cells should automatically populate with the correct answer.
The three cells have been named per "metres", "yards", & "feet".

What am I doing wrong?