The 1.4m formula

My friend Gerard shared this one.

It measures 1.4m if you stretch it out. Brilliant.

Keep them coming.

=IF(AND( $N97<>1,$O97<>1),$F97*$I97 * IF( AND( HeavyVehInd=2, X$4>=RoadStartYr), (1-$L97),(1-$K97))*(1-INDEX( X$5:X$7, MATCH($Q97,$Q$5:$Q$7,0))), IF(AND($N97=1,$O97=1), IF(OR(BiomassInd=1,AgInd=1),0, IF(X$4>= MAX(BiomassStartYr,AgStartYr), $F97*$I97* IF(AND(HeavyVehInd=2,X$4>=RoadStartYr), (1-$L97), (1-$K97))*(1-INDEX(X$5:X$7,MATCH($Q97,$Q$5:$Q$7,0))),0)), IF($N97=1,IF(BiomassInd=1,0, IF(X$4>=BiomassStartYr, $F97*$I97* IF(AND(HeavyVehInd=2,X$4>=RoadStartYr), (1-$L97), (1-$K97))*(1-INDEX(X$5:X$7, MATCH($Q97,$Q$5:$Q$7,0))),0)), IF($O97=1, IF(AgInd=1,0, IF(X$4>=AgStartYr, $F97*$I97*IF(AND(HeavyVehInd=2, X$4>=RoadStartYr), (1-$L97),(1-$K97)) * (1-INDEX(X$5:X$7,MATCH($Q97,$Q$5:$Q$7,0))),0))))))

Comments

Sign in or become a Financial Modelling Handbook member to join the conversation.
Just enter your email below to get a log in link.

Subscribe to Financial Modelling Handbook

Don’t miss out on the latest financial modelling guides. Sign up now to get access to the library of members-only guides.
jamie@example.com
Subscribe