DavidRingstrom.com
Concatenation Trick
Copying Cell Contents Down
Dec 02
The AND function allows you to tests for two or more conditions in an IF statement. =IF(AND(A1>=1,A1<=100),"Between 1-100","Other")
Exploring Microsoft Excel's Hidden Treasures