calcul

  • Abrisud
    Demandé le 12 octobre 2016 à 05:11

    Bonjour,

    je cherche comment faire si je rentre un chiffre dans une cellule A et une cellule B

    afficher un texte erreur si il y a une difference de + ou - 100

    par exemple 

    cellule A = 100

    cellule B = 200 OK

    ou 

    cellule A = 100

    cellule B = 250 NON difference de + 100

    Merci encore pour votre aide

  • Mike_G Jotform Support
    Répondu le 12 octobre 2016 à 06:22

    I'm sorry, but I'm afraid I'm not understanding what you need with your requirements.

    May we know where does the value of Cell A and Cell come from? Is it going to be entered by your respondents or is it from another computation? Are you referring to an excel cell or you are going to use a regular text field for A and B?

    Also, to my understanding of the calculation, if the difference between Cell A and Cell B is less than or more than 100 then an error message will show, is that correct?

    Can you help us understand your concern by providing us more details, please?

    We will wait for your response. Thank you.