Options
edited 12/16/20

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

• ✭✭✭✭✭✭
Options

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

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.

• ✭✭✭✭✭✭
Options

Excellent!

You're more than welcome!

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.

• ✭✭✭✭✭
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!
• Options

still doesn't work 😅

• ✭✭✭✭✭✭
Options

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

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.

• 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!

• ✭✭✭✭✭✭
Options

Excellent!

You're more than welcome!

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!