PFA a file where with the help of "IF " Function ,a calculation needs to be done.
Explanation Of The Problem-
There are 3 kinds of broker - "AUC", "PVT" and " any other Broker ".
For AUC -Brokerage shall be .20% of Tea Value plus Service Tax.
For PVT -Brokerage shall be .15% of Tea Value.
For Any Other broker like DRK, ABP - Brokerage shall be .20% of Tea Value.
Thanks,
Anibha Jain
Bookmarks