IF ELSE with an AND?

[Kelston]

I am trying to write a VBA macro that scans down a column and when
value is lower in cell before and lower in cell after (i.e. at a peak
and a variable is set at specific value that information is then copie
onto another spread sheet.

In old spreadsheet system I used I could put
IF r2c2<r1c2 AND r3c2<r2c2 AND x=yes THEN
"tell it what to do"
END IF

Is there a way in VBA to use AND in an IF...END IF statement?
Or should I be using some other formula

 

[Frank Kabel]

Hi
something like
if range("B2").value<range("B1").value and _
x="yes" then
'do something
end if