26th April 2006, 08:11 AM
|
|
Member
|
|
Join Date: Jan 1970
Posts: 578
|
|
Quote:
|
Originally Posted by Twodogs
Good Morning Excel Champs,
Is it possible to have more than one IF?
What I want to do is look at 3 columns and IF they meet requirements I then perform a formula on a fourth column.
Is this where AND comes into the formula setup?
Thanks
Twodogs
|
You can have as many as seven IF's in any single formula. The AND can be used in conjunction with IF to test if two variables are met.
Here is one that I use in one of my programs:
=IF(AND(85<=Q4,Q5<=75),"A",IF(Q6<=75,"B",IF(AND(75>=Q6,Q7<=65),"C","D"))) |