D
Dos Equis
Hi all,
I've set up a spreadsheet to update from a formula. The spreadsheet is
designed to track monthly information and does that well, but the
formula is allowing(causing?) these cells to change even after that
month is passed.
i.e:
Jan = $275
Feb = $325
Mar = $300
Apr = $450
Total = $1,350
With the formula setup, after a certain total is reached, Jan ='s $315,
Feb = $364... I want the totals to remain static after they are figured
and not to adjust as changes are made later.
Does anyone know of an easy way to accomplish this?
TIA,
Byron
I've set up a spreadsheet to update from a formula. The spreadsheet is
designed to track monthly information and does that well, but the
formula is allowing(causing?) these cells to change even after that
month is passed.
i.e:
Jan = $275
Feb = $325
Mar = $300
Apr = $450
Total = $1,350
With the formula setup, after a certain total is reached, Jan ='s $315,
Feb = $364... I want the totals to remain static after they are figured
and not to adjust as changes are made later.
Does anyone know of an easy way to accomplish this?
TIA,
Byron