## Thursday, August 20, 2015

### Excel formula to calculate commission on sales for different slabs

HI,

Although a flat-rate sales commission is fairly straightforward to calculate, most modern commission plans include tiers and bonus plans. In this post I will explain how to calculate a commission payout where slab structure is involved. Calculating commissions for as slab structure is difficult because you are required to calculate commission for different slabs at the different rate.

Below given us slab used for given example:

 Sales Amount Commission % 20000 0% 30000 5% 40000 7% 50000 10% 60000 12% 70000 13% 80000 14% 90000 15% 100000 16% 110000 17% 120000 18% 130000 19% 99999999 19%

so for commission for sales upto 20k is nil, for next 10k it is 5% of amount in excess of 20k and so on..

Refer excel attachment for formula & in 1st sheet & example for understanding in second sheet.

Cheers!!

## Saturday, August 15, 2015

### Excel VBA Macro to assign payment received to Invoices using FIFO method

Hi

Today i am sharing this fantastic template for assigning payment received to Invoices using FIFO method.

If you are not using any ERP or Accounting package then it is nightmare for accountant to manually assign payment received one by one to invoice, also there is risk of assigning payment twice or missing payments..

Just fill data in template & click on Image to run macro..

Cheers!!

Tags:
#Excel#VBA#MACRO#FIFO#INVOICE#PAYMENT

## Saturday, August 8, 2015

### Windows like calculator in excel using VBA macro

While working with excel need for calculator arises for doing manual calculations..

With this calculator in excel you can do basic functions & trigonometric functions too, also it has option for deleting last miss typed texts..

## Saturday, August 1, 2015

### Excel VBA Extract domain name from email address using Excel VBA Macro

Excel VBA Extract domain name from email address using Excel VBA Macro

How to Extract, follow steps as below:

Step 1 : Split email id from @ sign
Step 2: Get second portion of split result
Step 3: Now in domain name there could be more than one dots, so we will split value in step 2 using "." sign
Step 4: Store values so split in to array & remove last array
Step 5 : Remove last array value
Step 6 : Join array value using "."
Step 7: Result is your domain name

Check Code:
```Sub domain_name_old()

Dim a() As String

Dim domain As String

domain = "vba@sub.domain.com" 'ActiveCell.Value

domain = Split(domain, "@")(1)

a = Split(domain, ".")

ReDim Preserve a(UBound(a) - 1)

domain = Join(a, ".")

MsgBox "Domain name is : " & domain

End Sub

```

Method 2 ***

```

Sub domain_name2()

Dim a() As String

Dim domain As String

domain = ActiveCell.Value

domain = Split(domain, "@")(1)

domain = Replace(domain, "." & Right(domain, (Len(domain) - InStrRev(domain, "."))), "")

End Sub

```