How do I set up a formula with multiple criteria?

E

EFloyd

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.
 
D

Don Guillett

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ASK Field Formatting 1
Fill in the blanks 1
Summarizing with multiple conditions - Formula solution needed 2
HELP. I need an "IF" formula with a lot of information 5
Logical formatting for multiple values 1
VLOOKUP or SUMIF for Multiple Criteria 2
Using countif with multiple criteria 0
Using subfilds 1

Top