Formula to calculate Tax values on net value depending on dealer codes

**abhinavbinkar** · 12-30-2018, 02:45 AM

Please refer file attached.

I needed formula in my sheet name "VF05_UTILITY" in columns BB, BC & BD (Tax values) depending on tax rates(column A, B & C) and Dealer Code (sheet: "Dealer Details") to calculate whether the dealer code come in SGST / CGST or IGST.

**Bo_Ry** · 12-30-2018, 03:00 AM

Please try at BB3 and copy across

=A3/100*$AZ3*(VLOOKUP($H3,'DEALER DETAILS'!$A$5:$P$17,MATCH(BB$1,'DEALER DETAILS'!$A$4:$P$4,),)="Yes")

or

=A3/100*$AZ3*(VLOOKUP($H3,'DEALER DETAILS'!$A$5:$P$17,COLUMNS($BB$3:BB3)+13,)="Yes")

**abhinavbinkar** · 12-30-2018, 03:09 AM

Excellent. Thank you so much.

SOLVED.

Formula to calculate Tax values on net value depending on dealer codes

LinkBack

Thread Tools

Rate This Thread

Display

Formula to calculate Tax values on net value depending on dealer codes

Re: Formula to calculate Tax values on net value depending on dealer codes

Re: Formula to calculate Tax values on net value depending on dealer codes

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Formula to calculate pay depending on job code rates

Need help fixing a formula [ to calculate pay depending on what time you work]

Help to calculate values depending of month data

Formula to calculate totals depending on Drop Down Menu

Formula to calculate distance between to post codes in Excel

[SOLVED] Calculate Averages depending on other values

[SOLVED] Formula to calculate sum depending on a value

Bookmarks

Bookmarks

Posting Permissions