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