ExcelBanter - using handle with formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - using handle with formula (https://www.excelbanter.com/excel-worksheet-functions/182079-using-handle-formula.html)

Harry

using handle with formula

When I use handle to go down to next cell the formula changes like it should
but the number stays the same as the cell I pulled down. Why?

PCLIVE

using handle with formula

Press F9 to force Calculation. Set calculation to automatic.

Tools|Options|Calculation|Automatic

HTH,
Paul

--

"Harry" wrote in message
...
When I use handle to go down to next cell the formula changes like it
should
but the number stays the same as the cell I pulled down. Why?

All times are GMT +1. The time now is 02:07 AM.