I'm really struggling with this one.
I'm trying to create a formula that can return an outcome based on the value of another cell.
So I have a table with a list of plans, each plan have a minimum payment option (these minimum payments change based on the value of balances typed in).
I have another box that specifies yes or no if a contractual payment is affordable or not, as if it's not affordable the type of plan that should appear would be different.
So if Yes and payment is less than minimum payment, then specify this plan, if yes and payment is more or equal to this other minimum payment, then specify this plan, if No and payment is more than this minimum payment, and Yes for change in circumstances in the next 12 months, specify this payment.
I have tried IF And formulas, IF formulars and CHOOSE formulas.
I'm struggling to get it to work
for example "=IF(G22="YES",CHOOSE((J22>D15)+(J22>=D16)+ (AND(J22> 0, J22<D15)),"COL","PTP","Term Ext))"
Where "term ext" should be displayed, it just won't do it, it just shows "COL", I can never get it to display more than two of the outcomes, if it will it usually just comes up with VALUE.
I'm trying to create a formula that can return an outcome based on the value of another cell.
So I have a table with a list of plans, each plan have a minimum payment option (these minimum payments change based on the value of balances typed in).
I have another box that specifies yes or no if a contractual payment is affordable or not, as if it's not affordable the type of plan that should appear would be different.
So if Yes and payment is less than minimum payment, then specify this plan, if yes and payment is more or equal to this other minimum payment, then specify this plan, if No and payment is more than this minimum payment, and Yes for change in circumstances in the next 12 months, specify this payment.
I have tried IF And formulas, IF formulars and CHOOSE formulas.
I'm struggling to get it to work
for example "=IF(G22="YES",CHOOSE((J22>D15)+(J22>=D16)+ (AND(J22> 0, J22<D15)),"COL","PTP","Term Ext))"
Where "term ext" should be displayed, it just won't do it, it just shows "COL", I can never get it to display more than two of the outcomes, if it will it usually just comes up with VALUE.