Hi all, I'm wondering if there's a formula that could help me simplify the following calculation. I am checking whether the result of my calculation is within a specific range (between -1 and 1). To give you an example, here's how I'm checking whether -1<(A1+B1)<1:
Question: is there a way to simplify the
part? I.e., and I'm totally making this up, something along the lines of
My issue is that the A1+B1 part of the calc is actually a lot more complex, and I'd like to clean my formulas as clean as possible and not repeat the summation formula multiple times.
p.s. Would prefer to avoid using VBA/UDFs for this.