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