View original (French)

How to do "different from" in excel

Solved
UsulArrakis Posted messages 7683 Status Contributeur -  
 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

Answer 1 / 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
UsulArrakis Posted messages 7683 Status Contributor 3 195
 
thank you so much

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