Ad Free CAclubindia and Daily Updates on your Mobile. Subscribe Now!

Expense head in excel with formula

sumit (CA Final) (284 Points)

13 August 2019

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.

Reply
Follow
Share

10 Replies

Ishan aggarwal (student) (58 Points)
Replied 13 August 2019

what exactly you want explain

Upgrade to CAclubindia Pro. Subscribe Now!

Ishan aggarwal (student) (58 Points)
Replied 13 August 2019

CHECK AND REPLY

Attached File : 219357 20190813190213 360438 20190813182544 excel formula.xlsx downloaded: 180 times

1 Like

sumit (CA Final) (284 Points)
Replied 14 August 2019

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.

Attached File : 360438 20190814103555 purchase register.xls downloaded: 152 times

Shubham Sharma (Accountant ) (148 Points)
Replied 14 August 2019

good clarification and information...

Ishan aggarwal (student) (58 Points)
Replied 14 August 2019

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

Attached File : 219357 20190814172404 done.xls downloaded: 147 times

Upgrade to CAclubindia Pro. Subscribe Now!

Ishan aggarwal (student) (58 Points)
Replied 14 August 2019

ONE CAN ADD AS MUCH AS 256 ARGUMENTS IN EXCEL FORMULAS

1 Like

sumit (CA Final) (284 Points)
Replied 19 August 2019

Thank you so much, Mr. Ishan Aggarwal.

sumit (CA Final) (284 Points)
Replied 19 August 2019

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

sumit (CA Final) (284 Points)
Replied 19 August 2019

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