Nested If formula

Question

I'm looking to help to create a formula for a field REQUESTED LOAN AMOUNT that I am looking to have a formula based on the following logic.

I have a list that users can choose. Transaction Type
Acquisition, Refinance, Supplemental

There is a radio box Loan Req Input - the user selects one either LTV or Loan Req $ Input.

The formula I’m looking to write looks at the selection Transaction Type and then to the Loan Req Input and performs the calculation

If Acquisition and LTV selected, then multiply Acq price * LTV Request Input, if $ Input then use the $ Loan Request Input

If Refinance and LTV selected, then LTV Request Input * Value, if $ Input than use $ Loan Request Input

the same is for supplemental like the refinance.

Thank you,

MarkShnierYou · Accepted Answer

Unlike Excel, the fomulas are easier and typically do need "nesting". You just list all the tests under one IF and the formula will take the first one that is true.

IF(

[Transaction Type]="Acquisition" and [Loan Req Input]="LTV",

[Acq price] * [LTV Request Input],

[Transaction Type]="Acquisition" and [Loan Req Input]="$ Input",

[$ Loan Request Input],

[Transaction Type]="Refinance" and [Loan Req Input]="LTV",

[LTV Request Input] * [Value],

[Transaction Type]="Refinance" and [Loan Req Input]="$ Input",

[$ Loan Request Input],

etc .....

then end with a closing ) to close the IF

EFC · Answer

Perfect.  I need to think a little different than Excel sometimes. Thank you.

Sign up

Login to the community