mardi 15 décembre 2020

IF AND statement in MS WORD

I need a statement that gives a certain amount depending on the field value: If x is in the range between 10 and 20 then the answer is 15 if not then it should go to identical statement with a different range. I cant seem to get the first part working, this is what I got so far: {=IF(AND(x>10,x<20)"yes","no")}

Aucun commentaire:

Enregistrer un commentaire