Average DSCR calculation for only repayment years exclusive #Div/0! values

[GVN KUMAR]

Sir
Debt Service coverage ratio calculation only for repayment years
incase 2019 to 2024 or 2020 to 2025 year
but average formula give all year 2019 to 2025 but 0 repayment year #Div/0! so average also #Div/0!
so we are change formula only values years average
so each time manual change average formula
→how to write any automatic exclusive "#Div/0!" value formula

 

[bosco_yip]

Maybe,

In B13, copied across to H13

=IF(B12,ROUND(B8/B12,2),"")

Regards
Bosco

 

[GVN KUMAR]

Sir bosco_yip nice working formula sir
thank you for ur suggestion sir
thank you sir thank you