Originally Posted by sldfghtrike

that did it, thank you very much. I looked at the formula and I see why your and formula worked. Basically when I tried doing it I was thinking of doing some IF statements, could never get it to work.