Logic tables

I have used excell for years with simple formulas. Now I need to use what I tem logic flows. Here is a description of what I need to accomplish. I need: If Cell B1 is greater than 100 and less than ...