Hello,

I have this formula that is working but I find it quite long so I was wondering if it can be shorten

=MIN(1,(D$263+Transpose!$Q2-IF(Transpose!$O2=0,D$264,Transpose!$O2))%)*Transpose!$P2+
MIN(1,(D$263+Transpose!$T2-IF(Transpose!$R2=0,D$264,Transpose!$R2))%)*Transpose!$S2+
MIN(1,(D$263+Transpose!$W2-IF(Transpose!$U2=0,D$264,Transpose!$U2))%)*Transpose!$V2