Want to make formula to percentage slab

I want insert a formula in excle which can help to know the slab comes under which percentage slab 

Example 

If resolution is 

1% then slab will be update as 0-30%slab 

31% then slab will be update as 30-50%

51% then 50-80%

81% then 80-100%

101% then it have to show morethen 100%

 

Every time I am doing this manually but it taking so many time if I update resolution coloum can percentage slab colunm will update automatically as I need 

Plz help out of this if possible 

Thank u

 

 

Replies (1)
Use vlookup and hlookup as appropriate.

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
ARTICLESHIP 22 October 2026
Articleship intern

Srinath Manikanta

Hyderabad

CA Inter

View Details
Company
Featured 07 November 2026
Chartered Accountant

DPV & Associates

Chennai

CA

View Details
Company
Featured ARTICLESHIP 31 October 2026
CA Articleship

apricus india

Navi Mumbai

CA Inter

View Details
Company
ARTICLESHIP 14 November 2026
Article Assistant

Jitendra Agarwal & Associates

Bengaluru

CA Inter

View Details
Company
ARTICLESHIP 20 October 2026
CA ARTICLE

AMKN & CO

Noida

CA Inter

View Details
Company
12 November 2026
Auditor

Oz Taxation

Vijayawada

Graduate (Any)

View Details
Company
16 November 2026
Indirect Tax Associate

Sekhri Kanodia & Associates

Mumbai

B.Com

View Details
Company
10 November 2026
Direct Tax Manager

CAAQ CONSULTANCY PVT LTD

New Delhi

CA Final

View Details