paulcherianc
Registered User.
- Local time
- Yesterday, 19:43
- Joined
- Aug 15, 2013
- Messages
- 86
Can any one help me to fix the formula
Monthly Cost: IIf(AND([FromDate]<[LeaseStartDate]<[ToDate]),([ToDate]-[LeaseStartDate])*[MonthlyRent]*12/364,IIf((AND([FromDate]<[LeaseStartDate]<[ToDate]),([LeaseEndDate]-[FromDate])*[MonthlyRent]*12/364,[MonthlyRent])):banghead:
Monthly Cost: IIf(AND([FromDate]<[LeaseStartDate]<[ToDate]),([ToDate]-[LeaseStartDate])*[MonthlyRent]*12/364,IIf((AND([FromDate]<[LeaseStartDate]<[ToDate]),([LeaseEndDate]-[FromDate])*[MonthlyRent]*12/364,[MonthlyRent])):banghead: