The syntax for AND is as follows:
So, if logictest1 and logictest2 is true, returns true.
Now, you can add in an IF, for:
The above code, will place the value of A2, into what cell is testing for the value, as long as A2 is less than A3, AND A2 is Less than 100.
I hope this helps you out!