calcul

  • Profile Image
    Abrisud
    Asked 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

  • Profile Image
    Mike_G
    Answered 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.