Please help me with this if formula

andri witana

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

Andrée Starå

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!

Andrée Starå

@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.

J Tech

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,""))))

andri witana

still doesn't work 😅

Andrée Starå

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!

andri witana

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å

@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.