ultracyclist
Active Member
 Joined
 Oct 6, 2010
 Messages
 255
 Office Version

 365
 Platform

 Windows
Hi,
I’m using the following formulas to calculate depreciation costs over a 6 year period assuming the first year is 2020. Looking for help on how I adjust the formulas if the starting year is 2021 thru 2030 so it always maintains a 6 year rolling period based on the first year. In column V, I have a dropdown list that goes from 2020 through 2030
Thansks,
Tom
I’m using the following formulas to calculate depreciation costs over a 6 year period assuming the first year is 2020. Looking for help on how I adjust the formulas if the starting year is 2021 thru 2030 so it always maintains a 6 year rolling period based on the first year. In column V, I have a dropdown list that goes from 2020 through 2030
Depreciation Schedule.xlsx  

M  N  O  P  Q  R  S  T  U  V  W  X  Y  Z  AA  AB  AC  AD  AE  AF  AG  
1  Hardware Cost  Hardware Purchase Year  Cost Type  2020  2021  2022  2023  2024  2025  2026  2027  2028  2029  2030  
2  $197,762  2020  Hardware  0  0  0  0  0  0  2020  
3  2021  
4  2022  
5  2023  
6  2024  
7  2025  
8  2026  
9  2027  
10  2028  
11  2029  
12  2030  
Sheet1 
Cell Formulas  

Range  Formula  
P2  P2  =IF($N2="2020",$M2*10%,0) 
Q2  Q2  =IF($N2="2020",$M2*20%,IF($N2="2021",$M2*10%,0)) 
R2  R2  =IF($N2="2020",$M2*20%,IF($N2="2021",$M2*20%,IF($N2="2022",$M2*10%,0))) 
S2:T2  S2  =IF($N2="2020",$M2*20%,IF($N2="2021",$M2*20%,IF($N2="2022",$M2*20%,0))) 
U2  U2  =IF($N2="2020",$M2*10%,IF($N2="2021",$M2*20%,IF($N2="2022",$M2*20%,0))) 
Cells with Data Validation  

Cell  Allow  Criteria 
N2:N12  List  =$AG$2:$AG$12 
Thansks,
Tom