shaikhrulez
Active Member
Hello guys, here I'm posting a challenge for you all.
When a certain amount is entered in Cell E3, it would calculate Commission on the basis of below mentioned criteria;
When a certain amount is entered in Cell E3, it would calculate Commission on the basis of below mentioned criteria;
- If the amount entered is upto Rs. 100,000 the commission charge would be 0.10% or minimum Rs. 150 whichever is higher.
- If the amount entered is upto Rs. 1,000,000 the commission charge would be 0.05% or minimum Rs. 175 whichever is higher.
- If the amount entered is over Rs. 1,000,000 the commission charge would be 0.04% or minimum Rs. 600 whichever is higher.
Attachments
Last edited: