Forum Discussion
Divide and display value if in appropriate tax year
I am trying to make a sheet that will work out a depreciation for a set of tools for each financial year given depreciation of a given number of years for each tool. I want to go along a row and che...
Ok, so the answer is that using the reference $A$1 to instead of A1 in a formula will stop it from updating to B1 as you drag the formula to the next cell to the right.
This is probably already covered in other questions elsewhere.
It also works with just fixing the column as in $A1 or jst the row as in A$1.
therefore starting at L3 my formula was =IF(AND($J3<=L$2,L$2<=$K3),$H3,0)
and simply dragging it over the entire field updated all the cells correctly.
therefore starting at L3 my formula was =IF(AND($J3<=L$2,L$2<=$K3),$H3,0)
and simply dragging it over the entire field updated all the cells correctly.