Excel formula for calculating payout under different slabs using logic formula

569 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

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
ARTICLESHIP 07 July 2026
Articleship

Jawahar and Associates Chartered Accountants

Hyderabad

CA Inter

View Details
Company
19 June 2026
Accounts Executive

Getfive Advisors Pvt. Ltd.

Ahmedabad

CA Inter

View Details
Company
ARTICLESHIP 20 June 2026
Articleship

RB KESHRI & CO

Mumbai

B.Com

View Details
Company
ARTICLESHIP 08 July 2026
Articles

AJAY SINGH AND CO LLP

Thane

CA Final

View Details
Company
ARTICLESHIP 30 June 2026
Taxation Content Writer Intern

Interactive Media Pvt Ltd.

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 24 June 2026
CA Article Trainee

Rahul Dang & Associates

Pune

CA Inter

View Details
Company
ARTICLESHIP 24 June 2026
ARTICLE ASSISTANT

BHUPINDER SHAH AND COMPANY

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 27 June 2026
CA Articled Trainee And Paid Assistant

SKAA & Associates

New Delhi

CA Inter

View Details