Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie:
i.oana din Bucuresti
 | Femeie
20 ani
Bucuresti
cauta Barbat
20 - 45 ani |
|
Mrrrr
AdMiN
 Inregistrat: acum 18 ani
Postari: 2241
|
|
You want to check if A3 equals one of the following values: 1,3,7,10 and return 1, else return 0
You can use:
=IF(OR(A3=1, A3=4, A3=7, A3=10),1,0)
or
=(OR( A1 = {1,4,7,10} ) ) * 1
or
=--(OR( A1 = {1,4,7,10} ) )
or
=IF(ISERR( FIND("\"&A1&"\", "\1\4\7\10\")), 0, 1)
or
---comment--- if A1 are 1,4,7,10,13,16,19,22,25,... etc ---
=IF(MOD(A1, 3)-1, 0, 1)
_______________________________________
|
|
| pus acum 10 ani |
|