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 ARTICLESHIP 28 October 2026
CA- Inter and Articles

N N V Satish & Co.,

Hyderabad

CA Inter

View Details
Company
ARTICLESHIP 22 October 2026
Articleship intern

Srinath Manikanta

Hyderabad

CA Inter

View Details
Company
13 October 2026
Accountant

Zerdi & Co. Chartered Accountants

Pune

B.Com

View Details
Company
12 October 2026
AUDIT , ACCOUNTS AND TAXATION

KDSS

New Delhi

B.Com

View Details
Company
ARTICLESHIP 20 October 2026
CA ARTICLE

AMKN & CO

Noida

CA Inter

View Details
Company
12 October 2026
Finance

I-Genext Consulting Private Limited

New Delhi

CA

View Details
Company
19 October 2026
Accountant

Jari Saree Center

New Delhi

Others

View Details
Company
19 October 2026
Accountants/Articles (Freshers/Experienced)

ADY & CO.

New Delhi

Graduate (Any)

View Details