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 check if that column year (from Row 2) is within a range of years (J and K columns give the start and end) and if it is have that cell equal to the value of the H column.
I made a formula to do this but it requires updating for every single cell as the feilds move when you drag the formula across.
Any Ideas
2 Replies
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.
