Yes, that formula did give me the heebie-geebies. When I need to do a complex calculation like that in Excel, I break it up into multiple cells each doing a su

Yes, that formula did give me the heebie-geebies. When I need to do a complex calculation like that in Excel, I break it up into multiple cells each doing a subset of the calculation, then I have a result cell that brings the results together at the end. that way I can work on manageable formulas and can check the results of each. It’s probably less efficient from a processing and memory standpoint but I rarely work on large data sets and the gains in reliability are well worth it.