Are there such things as variables within an Excel formula?
I hate repeating functions, particularly in Excel formulas. Is there any way that I can avoid something like:
=IF( VLOOKUP(A1, B:B, 1, 0) > 10, VLOOKUP(A1, B:B, 1, 0) - 10, VLOOKUP(A1, B:B, 1, 0)..