IF STATEMENT

[Guest]

I'm attempting to write a formula stating that if a loan is a refinance, add
3 business days to the close date, if not, use the close date. Can someone
help me?

 

[Tom Ellison]

Dear Lori:

Please refer to the functions IIf() and DateAdd() in the online help. This
will work together to do what you want.

Tom Ellison

 

[John Vinson]

I'm attempting to write a formula stating that if a loan is a refinance, add
3 business days to the close date, if not, use the close date. Can someone
help me?

The Access function is IIF: in a calculated field you can type

NewDateField: DateAdd("d", IIF([LoanType] = "Refinance", 3, 0), [Close
Date])

using of course your own fieldnames and the correct logic to identify
which loans are refinances.

John W. Vinson[MVP]