Resolve unexpected formula changes in Excel caused by volatile functions like INDIRECT affecting AVERAGE and IF calculations.