Forum Discussion
Solved
If Function
Dear Everyone,
Please suggest me a formula for the following excel:
| A | B | C | D | E | F | |
| 1 | Particulars | Criteria 1 | Result | Criteria 2 | Result | |
| 2 | 101010 | If A2 starts with 1, C2 will show BS | BS | If A2 starts with 1, F2 will show ASSET | ASSET | |
| 3 | 201010 | If A3 starts with 2, C3 will show BS | BS | If A3 starts with 2, F3 will show LIABILITY | LIABILITY | |
| 4 | 301010 | If A4 starts with 3, C4 will show PL | PL | If A4 starts with 3, F4 will show INCOME | INCOME | |
| 5 | 401010 | If A5 starts with 4, C5 will show PL | PL | If A5 starts with 4, F5 will show EXPENSE | EXPENSE |
Thanks in advance.
Oliullah_Siddique In C2 you could use:
=CHOOSE(LEFT(A2),"BS","BS","PL","PL")and in F2:
=CHOOSE(LEFT(A2),"ASSET","LIABILITY","INCOME","EXPENSE")Copy down
Oliullah_Siddique In C2 you could use:
=CHOOSE(LEFT(A2),"BS","BS","PL","PL")and in F2:
=CHOOSE(LEFT(A2),"ASSET","LIABILITY","INCOME","EXPENSE")Copy down
- Thanks a lot. Your function worked very well Riny_van_Eekelen.
