Need to speed up Spreadsheet

Hi Patrick2788

Thanks for taking a look and giving examples! I just set up the 'Test Calc' as a simple workbook for testing macros, but actually your examples for modifying the formulas are really interesting. I've not really come across using formulas in this way before.

My main calc is mostly a mess of nested 'IF' functions. Is there an easy way of making these more efficient? or am I going to have to go through each formula one-by-one trying to rewrite for efficiency? I know AI can sometimes help in this area, but it's usually after a long battle getting the ruddy thing to understand the requirements. 

Many thanks.