Re: multiple AND statements

Giganews Newsgroups
Subject: Re: multiple AND statements
Posted by:  Don Guillett (donal…@281.com)
Date: Sun, 26 Oct 2003

try
=if(and(a1>5,a1<=10,1,2)

"Gale Gorman" <ggorm…@houston.rr.com> wrote in message
news:BHXmb.10024$xv4.13…@twister.austin.rr.com...
> 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
> Houston
>
> ,

Replies

In response to

multiple AND statements posted by Gale Gorman on Sun, 26 Oct 2003