How do I set up a formula with multiple criteria?
 

I am trying to set up a formula. The IF formula would logically be best but I
am not sure.I would like for it to, for example, say if the cat is orange but
also white then it is a tabby. I have a few of these "situations" where I
need to specify a true/false but they have to relate to each other. For
example, if the cat has proven to ba a tabby then it also has to be a short
tail. In short I need to be able to, with many different instances, be able
to know if it is true if the cat is a short tail tabby. If anyone could help
me I would very much appreciate it.

nested if's something like
=if(and(cat="a",cat="b"),1,2)
=if(and(cat="a",cat="b"),if(cat=c,1,2))

--
Don Guillett
SalesAid Software

"EFloyd" wrote in message
...
I am trying to set up a formula. The IF formula would logically be best
but I
am not sure.I would like for it to, for example, say if the cat is orange
but
also white then it is a tabby. I have a few of these "situations" where I
need to specify a true/false but they have to relate to each other. For
example, if the cat has proven to ba a tabby then it also has to be a
short
tail. In short I need to be able to, with many different instances, be
able
to know if it is true if the cat is a short tail tabby. If anyone could
help
me I would very much appreciate it.