DIBBeneficioDesdobrado D7

=IF(MID(OpcaoBeneficioDesdobrado;1;1)="2";DIBOriginario;IF(MID(OpcaoBeneficioDesdobrado;1;1)="3";DIBDerivado;""))

0.###############

---

DataDesdobro1 F5

dd/MM/yyyy

---

DataDesdobro2 F6

dd/MM/yyyy

---

DataDesdobro3 F7

dd/MM/yyyy

---

DataDesdobro4 F8

dd/MM/yyyy

---

DataDesdobro5 F9

dd/MM/yyyy

---

OpcaoBeneficioDesdobrado D5

0.###############

VALUE_IN_RANGE OpcoesDesdobro!A:A

---

QuotaDevida1 G5

# ?/?

---

QuotaDevida2 G6

# ?/?

---

QuotaDevida3 G7

0.###############

---

QuotaDevida4 G8

# ?/?

---

QuotaDevida5 G9

# ?/?

---

QuotaPaga1 H5

# ?/?

---

QuotaPaga2 H6

# ?/?

---

QuotaPaga3 H7

# ?/?

---

QuotaPaga4 H8

# ?/?

---

QuotaPaga5 H9

# ?/?

---

QuotaProporcional1 I5

=IF(DataDesdobro1=DIBBeneficioDesdobrado;QuotaDevida1-QuotaPaga1;
(((DAY(DataDesdobro1)-1)/30))+((MAX(30-DAY(DataDesdobro1)+1;1)/30)*(QuotaDevida1-QuotaPaga1)))

# ?/?

---

QuotaProporcional2 I6

=IF(DAY(DataDesdobro2)=1;QuotaDevida2-QuotaPaga2;
(((DAY(DataDesdobro2)-1)/30)*(QuotaDevida1-QuotaPaga1))+((MAX(30-DAY(DataDesdobro2)+1;1)/30)*(QuotaDevida2-QuotaPaga2)))

# ?/?

---

QuotaProporcional3 I7

=IF(DAY(DataDesdobro3)=1;QuotaDevida3-QuotaPaga3;
(((DAY(DataDesdobro3)-1)/30)*(QuotaDevida2-QuotaPaga2))+((MAX(30-DAY(DataDesdobro3)+1;1)/30)*(QuotaDevida3-QuotaPaga3)))

# ?/?

---

QuotaProporcional4 I8

=IF(DAY(DataDesdobro4)=1;QuotaDevida4-QuotaPaga4;
(((DAY(DataDesdobro4)-1)/30)*(QuotaDevida3-QuotaPaga3))+((MAX(30-DAY(DataDesdobro4)+1;1)/30)*(QuotaDevida4-QuotaPaga4)))

# ?/?

---

QuotaProporcional5 I9

=IF(DAY(DataDesdobro5)=1;QuotaDevida5-QuotaPaga5;
(((DAY(DataDesdobro5)-1)/30)*(QuotaDevida4-QuotaPaga4))+((MAX(30-DAY(DataDesdobro5)+1;1)/30)*(QuotaDevida5-QuotaPaga5)))

# ?/?