IF STATEMENT

L

LORIB

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?
 
T

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
 
J

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?
Click to expand...

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]
 
Top