Excel formula for calculating payout under different slabs using logic formula

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

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
Featured 18 July 2026
Senior Manager- Finance & Accounts

apricus india

Ahmedabad

CA

View Details
Company
20 July 2026
Senior GST Executive

Chandak Agarwal & Co

Mumbai

Graduate (Any)

View Details
Company
13 July 2026
AVP / VP - PCG Advisory

Workforce Connect

Mumbai

MBA

View Details
Company
23 July 2026
Senior Accountant

Felicity Adobe LLP

Bengaluru

CA Inter

View Details
Company
28 July 2026
Senior accountant

RJ Public School

Bengaluru

B.Com

View Details
Company
Featured 16 July 2026
Semi Qualified Company Secretary

Vakilsearch.com

Chennai

CS

View Details
Company
29 July 2026
ACCOUNTANT

ONESTEP GST SOLUTION

New Delhi

B.Com

View Details
Company
06 July 2026
Chartered Accountant (Indirect Taxation)

Gowra Ventures Pvt Ltd

Hyderabad

CA

View Details
Follow