Expense head in excel with formula

Dear All,

Please help me in excel formula. In the attached excel file, i want to get "Expense Head" in the column D with the help of formula where the value is more than "0".

 

Pls reply

 

Thank you.


Attached File : 360438 20190813182544 excel formula.xlsx downloaded: 126 times
Replies (10)

what exactly you want explain

 

CHECK AND REPLY

Dear Ishan,

Thank you so much for your prompt reply. This is what i exactly want. But when the data are large, then is there any other way for the solution? Pls find attached large data file.

Thank you.

good clarification and information... 

 LET'S BE HAPPY . AS I DONE YOUR WORK EASY

ONE CAN ADD AS MUCH AS 256 ARGUMENTS IN EXCEL FORMULAS

Thank you so much, Mr. Ishan Aggarwal.

Mr. Ishan,  great work. so you have entered every cell manually or is there any shortcut.??

Excel has limits on how deeply you can nest IF functions. Up to Excel 2007, Excel allowed up to 7 levels of nested IFs. In Excel 2007+, Excel allows up to 64 levels.

I have more than 64 levels. Above that excel does not allow to enter if formula

JUST ENTER 1 ARGUMENT AND

THEN COPY IT DESIRE NUMBER OF TIMES 

THEN CORRECT THE CELL REFERENCE 

THANKS 

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
ARTICLESHIP 07 November 2026
Article Assisstant

DPV & Associates

Chennai

CA Inter

View Details
Company
ARTICLESHIP 22 October 2026
Articleship intern

Srinath Manikanta

Hyderabad

CA Inter

View Details
Company
16 November 2026
Assistant Article

ZAK & Co. Chartered Accountants

Bengaluru

CA Inter

View Details
Company
28 October 2026
Assistant Director/ Associate Director-Finance & Accounting

Krea University

Chennai

CA

View Details
Company
Featured ARTICLESHIP 31 October 2026
CA Articleship

apricus india

Navi Mumbai

CA Inter

View Details
Company
24 October 2026
CA Industrial Trainee

Fytomax Nutrition Private Limited

Aurangabad

CA Inter

View Details
Company
12 November 2026
Tax Product Specialist

BharatX.ai

Gurgaon

B.Com

View Details
Company
Featured 07 November 2026
Chartered Accountant

DPV & Associates

Chennai

CA

View Details