Hi all.

Excel Forum Question 1.xlsm

The attached calculator uses a number of cells in order to arrive at a final calculation. This currently works as intended. However, when I attempt to comine these formulas into one, I end up with more than 8195 characters maximum. Using the excel binary save this works, but I would prefer not to use that, favouring xlsm, or xls format.

It is absolutely required this formula is used by one cell only. The reason is becuase there are one to many tasks >subtasks and I need to create many tasks each with subtasks along a single row.

If this cannot be reduced further, is there a way to reference a formula that can be shared by mulitple cells in order to provide a different result: e.g. like a VBA function. (No, I don't want to use VBA).

A lot of time and contributions from various people around this forum have contributed to this attached task calculator, for which I thank all concerned sincerely.

I would appreciate any advice in order to try and reduce this formula

Cheers

Excel Forum Question 1.xlsm