View original (French)

How to do "different from" in excel

Solved
UsulArrakis Posted messages 7683 Status Contributor -  
 Lizs -
Hello, can someone tell me how to include the "not equal to" variable in a function, either in Excel or Access?
For example: IF(x "not equal to" 24; true_value; false_value)

Thank you and Happy New Year!

1 answer

  1. didou
     
    Hello,

    the formula is in Excel: 
    =IF(B1<>24,"coucou","bonjour")


    in this case: if the cell is less than or greater than 24, the target cell = coucou
    if = 24, the target cell = bonjour

    see you later
    209
    1. UsulArrakis Posted messages 7683 Status Contributor 3 196
       
      thank you so much

      PS: my brother is nicknamed "didou," are you bro?
      0
    2. didou
       
      Yes, it's me. I wanted to tell you: You have been adopted.............................xD
      1