3 conditions in an IF statement - VBA

[aragorn179]

I want to create a VBA function that returns an answer based off three different conditions. I was going to write an IF function but was wondering how to incorporate the three different columns in excel into the function. For example would I write something along the lines of:
If A > 2 and B > 2 and C > 2 Then
D = X
elseif A > 2 and B < 2 and C > 2 Then
D = y
Else D = z
Endif
I just need some help writing the three column values in to return different conditions based on those values.
Thankyou

 

[Momentman]

Something like

For example using cells in the first row

if cells(1,"A")>2 and cells(1,"B")>2 and cells(1,"C")>2 then
......
End if

Or

If range("A1")>2 and range("B1")>2 and range(c1")>2 then
....
End  if

 

[aragorn179]

Thankyou so much. How would i do it though using a name, for example "WaterLevel" instead of "A1"?