What's the correct syntax for this (in vba)?
Sub testifthen()
if cells(1,1).value = "x" and if cells(2,1).value = "y" and if
cells(3,1).value = "z" then cells(4,1).value = "dinner's in the fridge"

End Sub