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
Hi,
One way
Formula:
Please Login or Register to view this content.
Assumes service tax is based on brokerage value not tea value.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
If you want the brokerage fee only, use Richards' suggestion, (check the Percentages used).
If it is the total including brokerage
Formula:Please Login or Register to view this content.
If you are using all the columns that your sample suggests then maybe, to get the total
Formula:Please Login or Register to view this content.
And for the brokerage only
Formula:Please Login or Register to view this content.
Last edited by Marcol; 07-22-2013 at 08:18 AM.
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
ThankssssMy work got Easy !!! thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks