Expense head in excel with formula

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.

 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