yaoi28lover
Registered User.
- Local time
- Tomorrow, 05:23
- Joined
- Apr 21, 2014
- Messages
- 12
Hello!
I am having a problem converting an excel formula, I already have converted some of it but an error always shows up. If anyone could help me with this one it is very much appreciated.
This is the excel formula:
(I'm not the one who made this but I can understand the flow of the formula. Sadly my co-worker (an OJT student) is not here anymore and I can't ask him about it.
Title: Days Left Before Due
=IF(COUNTA(N1214)=1,-50000,IF(COUNTA(L1214)=1,-50000,IF(I1214-'Date Now'!A1237<-1,(ROUNDDOWN(I1214-'Date Now'!A1237,0)),(IF(I1214-'Date Now'!A1237<0,ROUNDDOWN(I1214-'Date Now'!A1237,0),(ROUNDUP(I1214-'Date Now'!A1237,0)))))))
*Note:
N1214= Auditee's Reply
L1214= Auditees's Reply
I1214= Due Date
A1237= from the "Date Now" sheet calling position number
and this is my Access Formula:
Days Left Before Due: IIf([Auditee's Reply]=1,0 And [Auditee's Reply]=1,0) IIf[Due Date]-Now( ), 1), (Round ([Due Date]-Now( )= 0,0))
I tried to create this but I am having a problem with the commas and parentheses because I am totally a beginner with Access 2003. :banghead:
Pls. help me out guys. I really need this within a week so that I can finish up my database.
I am having a problem converting an excel formula, I already have converted some of it but an error always shows up. If anyone could help me with this one it is very much appreciated.
This is the excel formula:
(I'm not the one who made this but I can understand the flow of the formula. Sadly my co-worker (an OJT student) is not here anymore and I can't ask him about it.
Title: Days Left Before Due
=IF(COUNTA(N1214)=1,-50000,IF(COUNTA(L1214)=1,-50000,IF(I1214-'Date Now'!A1237<-1,(ROUNDDOWN(I1214-'Date Now'!A1237,0)),(IF(I1214-'Date Now'!A1237<0,ROUNDDOWN(I1214-'Date Now'!A1237,0),(ROUNDUP(I1214-'Date Now'!A1237,0)))))))
*Note:
N1214= Auditee's Reply
L1214= Auditees's Reply
I1214= Due Date
A1237= from the "Date Now" sheet calling position number
and this is my Access Formula:
Days Left Before Due: IIf([Auditee's Reply]=1,0 And [Auditee's Reply]=1,0) IIf[Due Date]-Now( ), 1), (Round ([Due Date]-Now( )= 0,0))
I tried to create this but I am having a problem with the commas and parentheses because I am totally a beginner with Access 2003. :banghead:
Pls. help me out guys. I really need this within a week so that I can finish up my database.