multiple AND statements

Giganews Newsgroups
Subject: multiple AND statements
Posted by:  Gale Gorman (ggorm…
Date: Sun, 26 Oct 2003

I need to test a cell with about 20 different conditions
like so:

IF (A1 < 5)(A1 >= 5 and < 10) ....etc.

What is the proper syntax for this?

Would I be better off writing a function?  I read that a VBA
function is MUCH slower but that is not really a problem.

Gale Gorman