What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    calcul

    Asked by Abrisud on October 12, 2016 at 05:11 AM

    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

    difference a
  • Profile Image
    JotForm Support

    Answered by Mike_G on October 12, 2016 at 06:22 AM

    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.