banner_ad

Excel formula for calculating payout under different slabs using logic formula

Knowledge resource 512 views 1 replies

Hi,

 

I have to calculate payout under different slabs using logic formula.

How can I do it.

Like if disbursement is 0- 25 Cr =first disb*1%

        If between 25-50 Cr = Second Disb*1.10% + all Disb* 1.%

 

What should be the formula here.

 

Replies (1)

https://docs.google.com/document/d/1DuJZe1J2h8-qpbKohksLQVNU7FUrtrs_2RrNJqGXR24/edit?usp=sharing


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
Featured 29 April 2026
Manager- Finance and Compliance

Naveen Fintech Pvt Ltd

Kolkata

CA Inter

View Details
Company
Featured 28 March 2026
Accountant

Ashok Amol & Associates

New Delhi

B.Com

View Details
Company
Featured 13 April 2026
GST CONSULTANCY

Abhishek G Agrawal & Co.

Korba

CA Final

View Details
Company
Featured 19 March 2026
Article Assistant

Gupta Sachdeva & Co. Chartered Accountants

New Delhi

CA Final

View Details
Company
Featured 14 April 2026
GST CONSULTANT

Abhishek G Agrawal & Co.

Korba

CA Final

View Details
Company
Featured 28 March 2026
CA Final

Ashok Amol & Associates

New Delhi

CA Final

View Details