Excel formula for calculating payout under different slabs using logic formula

570 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
06 July 2026
C.A./CA Inter OR pursuing C.A./GST/Accounts/Audit/IT - Head

Arvindkumar Maniar & Co.

Rajkot

CA

View Details
Company
25 June 2026
AUDIT MANAGER

JDAS & ASSOCIATES

New Delhi

CA

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

SKAA & Associates

New Delhi

CA Inter

View Details
Company
29 June 2026
Accountant (Finance & Compliance)

TRIEYEZ

Kolkata

CA

View Details
Company
22 June 2026
Finance Manager- Chartered Accountant

Triveni Turbine Limited

Bengaluru

CA

View Details
Company
Featured 15 June 2026
Senior Auditor

N. Dhawan & Co

New Delhi

CA Inter

View Details
Company
11 July 2026
CA Inter, CA Intermediate, CA IPCC, CA CPT , CA SemiQualifie

Vakilsearch.com

Chennai

CA Inter

View Details
Company
ARTICLESHIP 24 June 2026
ARTICLE ASSISTANT

BHUPINDER SHAH AND COMPANY

New Delhi

CA Inter

View Details