jeudi 26 février 2015

Excel the and-function in the if-function

I have problems with the if-function. I want to combine the and-function with the if-function. What i did was this:



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


What i know is that you can do it all manually this way:



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


My specific question is: is there anyway to write this formula shorter?


Thanks in advance


Aucun commentaire:

Enregistrer un commentaire