jeudi 26 février 2015

IF and AND in combination

I have problems with the IF function. I want to combine the AND function with it. What I did was:



If(and((C2:G2)>5,5);"Gehaald";"Niet gehaald")


I know you can do it all manually this way:



And(C2>5,5;D2>5,5...)


Is there any way to write this formula shorter?


Aucun commentaire:

Enregistrer un commentaire