Nested If formula
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 A...
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
