View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mohit Mohit is offline
external usenet poster
 
Posts: 3
Default how to use a IF(AND) formulae for more than seven conditions

I have 4 variables which give me 34 possible conditions.(A data with 4
columns and 34 rows).
The fifth column consists of an answer.
I need a formula, which gives me the answer if i enter my four variables.
I tried using IF(AND.....) but it can take only seven conditions whereas i
have 34 !!