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:
crazylife Profile
 | Femeie
25 ani
Bucuresti
cauta Barbat
25 - 47 ani |
|
TonyTzu
Moderator
 Inregistrat: acum 12 ani
Postari: 252
|
|
Source:
The one I used:
Nesting Multiple IF Statements Using Numeric Data
Consider cell A8 as the source cell. The data will be in numeric format, ranging from 1 to 40, and the data in the cell (e.g. D8) in text format.
Simply complete the value if false for each nests by "" (empty), and restart a nesting preceded by an &:
eg1:
=IF(A8=1,"one",IF(A8=2,"two",IF(A8=3,"three",IF(A8=4,"four",IF(A8=5,"five",IF(A8=6,"six",IF(A8=7,"seven","")))))))&IF(A8=8,...
eg2 (matricea metodei de evaluare a riscurilor INCDPM):
=IF(AND(F16=7;G16=1);3;IF(AND(F16=7;G16=2);4;IF(AND(F16=7;G16=3);5;IF(AND(F16=7;G16=4);6;IF(AND(F16=7;G16=5);7;IF(AND(F16=7;G16=6);7;IF(AND(F16=6;G16=1);3;"")))))))&IF(AND(F16=6;G16=2);4;IF(AND(F16=6;G16=3);5;IF(AND(F16=6;G16=4);6;IF(AND(F16=6;G16=5);6;IF(AND(F16=6;G16=6);7;IF(AND(F16=5;G16=1);3;IF(AND(F16=5;G16=2);4;"")))))))&IF(AND(F16=5;G16=3);4;IF(AND(F16=5;G16=4);5;IF(AND(F16=5;G16=5);5;IF(AND(F16=5;G16=6);6;IF(AND(F16=4;G16=1);2;IF(AND(F16=4;G16=2);3;IF(AND(F16=4;G16=3);4;"")))))))&IF(AND(F16=4;G16=4);4;IF(AND(F16=4;G16=5);5;IF(AND(F16=4;G16=6);6;IF(AND(F16=3;G16=1);2;IF(AND(F16=3;G16=2);2;IF(AND(F16=3;G16=3);3;IF(AND(F16=3;G16=4);3;"")))))))&IF(AND(F16=3;G16=5);4;IF(AND(F16=3;G16=6);4;IF(AND(F16=2;G16=1);1;IF(AND(F16=2;G16=2);2;IF(AND(F16=2;G16=3);2;IF(AND(F16=2;G16=4);2;IF(AND(F16=2;G16=5);3;"")))))))&IF(AND(F16=2;G16=6);3;IF(AND(F16=1;G16=1);1;IF(AND(F16=1;G16=2);1;IF(AND(F16=1;G16=3);1;IF(AND(F16=1;G16=4);1;IF(AND(F16=1;G16=5);1;IF(AND(F16=1;G16=6);1;"")))))))
|
|
| pus acum 6 ani |
|