Forum Discussion
IF FUNCTION
Hello everyone,
Would you please suggest me a formula for the following:
| 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 |
Please give me the formula.
Thank you.
No RepliesBe the first to reply