Please help me with this if formula

Options
andri witana
andri witana ✭✭
edited 12/16/20 in Formulas and Functions

Hi

I am trying to use if formula for a cell depend on other cell that is a dropdown

so basically if option A "PPN" choosed, so the cell formula will be =0.1*third cell

option B "Pph 4.2 subsidi" choosed, the cell formula will be =0.01*third cell

and so on


=IF([Jenis Biaya]@row="PPN";=0.1*[Dasar Pengenaan Pajak]@row;IF([Jenis Biaya]@row="Pph 4.2 subsidi";=0.01*[Dasar Pengenaan Pajak]@row;IF([Jenis Biaya]@row="Pph 4.2";=0.025*[Dasar Pengenaan Pajak]@row;IF([Jenis Biaya]@row="BPHTB";=0.05*([Dasar Pengenaan Pajak]@row-60000000)))))


i keep getting unparseable with this formula

plz help

Best Answers

Answers

  • J Tech
    J Tech ✭✭✭✭✭
    Options

    Try the below:


    =IF([Jenis Biaya]@row="PPN",0.1*[Dasar Pengenaan Pajak]@row,IF([Jenis Biaya]@row="Pph 4.2 subsidi",0.01*[Dasar Pengenaan Pajak]@row,IF([Jenis Biaya]@row="Pph 4.2",0.025*[Dasar Pengenaan Pajak]@row,IF([Jenis Biaya]@row="BPHTB",0.05*([Dasar Pengenaan Pajak]@row-60000000,""))))

    Regards

    J Tech

    If my response has helped you in any way or provided a solution to your problem, please consider supporting the community by marking it as Insightful, Vote Up, or Awesome. Additionally, you can mark it as the accepted answer, which will make it easier for others to find a solution or get help with a similar issue in the future. Your support is greatly appreciated!
  • andri witana
    Options

    still doesn't work 😅

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Answer ✓
    Options

    Hi @andri witana

    Try something like this.

    =IF([Jenis Biaya]@row = "PPN"; 0,1 * [Dasar Pengenaan Pajak]@row; IF([Jenis Biaya]@row = "Pph 4,2 subsidi"; 0,01 * [Dasar Pengenaan Pajak]@row; IF([Jenis Biaya]@row = "Pph 4,2"; 0,025 * [Dasar Pengenaan Pajak]@row; IF([Jenis Biaya]@row = "BPHTB"; 0,05 * ([Dasar Pengenaan Pajak]@row - 60000000)))))

    Did that work/help?

    I hope that helps!

    Be safe and have a fantastic week!

    Best,

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • andri witana
    Options

    thx @Andrée Starå . it helps a lot

    so basically;

    1. i should put space before and after *
    2. for decimal i should use , instead of . (this actually is not very 'keyboard friendly'

    thx a lot!

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Answer ✓
    Options

    @andri witana

    Excellent!

    You're more than welcome!

    Answers.

    1. No, the spacing doesn't matter.
    2. Yes

    Depending on your country/region, you'll need to exchange the comma to a period and the semi-colon to a comma.

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!