I'm creating a utility in Excel that takes mesh bad leveling raw data (49 values, 7x7 grid, with the center value being what all other values are being compared to). Some values are positive, some ...

More specifically, adding $ to cell references turns them from relative references to absolute or mixed references, so this should be the only time you use the dollar symbol manually in Excel.

I think you misunderstand. I know how to do that. What I'm looking for is a way to calculate the absolute value on the fly.<BR><BR>When entering the range on the series values, I'm currently using ...

Excel table formulas driving you crazy? Learn the fix to lock column references, prevent errors, and simplify your ...