Tip a Day - How To Keep A Constant In Excel And Other Spreadsheets - GeekBeat Tips & Reviews

2012-04-19 100

When creating a formula in Excel or most other spreadsheet programs we sometimes need one of the values to be dynamic (e.g. we can change it in one place and effect everywhere its referenced) but stay constant when we replicate that formula across rows or columns.