Please help me with this if formula

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

Find more posts tagged with

Accepted answers

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.

No, the spacing doesn't matter.
Yes

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

All comments

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.

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

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

andri witana

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

so basically;

i should put space before and after *
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.

No, the spacing doesn't matter.
Yes

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.