Mohit wrote:
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 !!


Till Excel 2003 you can have just 7 IF, while from Excel 2007 there would be
the possibilty to use more than 7.

I think you could use the VLOOKUP function, instead of IF.

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy