Hello,

I have this formula but am not getting the intended results, can anyone point out if anything's wrong with it?

=IF(year=0,0,IF(year=1,rent_year_1,IF(AND(year=2,year=3),rent_year_2_and_3,IF(AND(year=3,year=4),rent_year_4_and_5,0))))

Thanks