xtremeusta
New Member
- Joined
- Oct 9, 2022
- Messages
- 14
- Office Version
- 365
- Platform
- MacOS
can someone help me understand why this is returning false:
if use type = use type, if (cell = yes, then if year 1 is less than or equal to year 6 then index(refinance mortgage balance,match year), if cell = yes, if year 6 is > year 1 then index(mortgage balance, match year), if cell = no, then index(original original mortgage balance, match year)
=IF($C$22=$ER$21,IF($S$4="yes",IF($S$7<=ES20,INDEX('Assumption Amortization Refinan'!$K:$K,MATCH(ES20,'Assumption Amortization Refinan'!$G:$G,0)),IF($C$22=$ER$21,IF($S$4="yes",IF($S$7>ES20,INDEX('Assumption 1 Amortization'!$J:$J,MATCH(ES20,'Assumption 1 Amortization'!$F:$F,0))))))),IF($S$4="no",INDEX('Assumption 1 Amortization'!$J:$J,MATCH(ES20,'Assumption 1 Amortization'!$F:$F,0))))
if use type = use type, if (cell = yes, then if year 1 is less than or equal to year 6 then index(refinance mortgage balance,match year), if cell = yes, if year 6 is > year 1 then index(mortgage balance, match year), if cell = no, then index(original original mortgage balance, match year)
=IF($C$22=$ER$21,IF($S$4="yes",IF($S$7<=ES20,INDEX('Assumption Amortization Refinan'!$K:$K,MATCH(ES20,'Assumption Amortization Refinan'!$G:$G,0)),IF($C$22=$ER$21,IF($S$4="yes",IF($S$7>ES20,INDEX('Assumption 1 Amortization'!$J:$J,MATCH(ES20,'Assumption 1 Amortization'!$F:$F,0))))))),IF($S$4="no",INDEX('Assumption 1 Amortization'!$J:$J,MATCH(ES20,'Assumption 1 Amortization'!$F:$F,0))))