[SOLVED] calculation is way to slow

ok, thank you very much, will have a look

best regards

hi DonQuichotte,
I think in your worksheet there are some mistakes and some optimization to do.
1. Look at the formula in CELL D7 where there is a reference on cell E9 without value.
2. It seems to me that you can use more powerful formulas like INDEX and MATCH instead of Nested IF (slower calculation)
3. Do not use Instructions like =SUM(E2:) if you can use simply =E2 (more fast)
4. Last point: try using a template like mine attached. That can help to design the algorithm logic and make easier the testing and the optimization.Tables could be placed in another worksheet
I hope these suggestions could be useful
David
at462

Hi DonQuichotte
Maybe is possible!
But if you send to me your Excel worksheet let me try if I'm able to speed it up.
You can mail it directly to our mailbox altoswebsolutions.com/contact-us , if you like.
David
at462

hello,

my spreadsheet is little bit complex and the calculation is pretty slow in the frontend.. i think customers are going away because of this.. how can i make it faster?

thanks