Dear Shailyog,
Thank you very much it solves my problem. Both formulas are working but the second method is neat and easy in understand. Thank you again for your help.
Regards,
Waqar
What I need that In Category Column we could just enter the category name, in next row the category maybe different from the first one like:
1- OPD - 70% of Hospital Fee
2- Ultrasound - 50% of Hospital Fee
You could give me your email address, I could send you the sample file...
Hi All,
Is it possible to use some kind of formula to calculate the doctors Commission fee automatically from Total fee as per category wise?
Like for Example:
Column Heading:
Col "A" - Col "B" - Col "C" - Col "D" - Col "E" - Col "F"
Date - V.No. - Doctor Name - Category -...