Forum Discussion

Oliullah_Siddique's avatar
Oliullah_Siddique
Brass Contributor
Jun 21, 2022
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 w...
excel
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Jun 21, 2022

    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

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Jun 21, 2022

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

Resources