Help Required
 

Dear All,
I want macro or formula for the below mentioned querry pls help i am
entering data's in cell A, B and output to be displayed in cell C as follows
for eg:-
A B C
01/11/06 01/11/06 0
01/11/06 02/11/06 1
NA NA NA
01/11/06 NO Voilated
NO NO Voilated

Help Required
 

Maybe this will do it for you.........

=IF(B1="NO","Violated",IF(AND(A1="NA",B1="NA"),"NA ",IF(AND(LEN(A1)=5,LEN(B1)=5),B1-A1,"")))

Vaya con Dios,
Chuck, CABGx3




"kiran" wrote:

Dear All,
I want macro or formula for the below mentioned querry pls help i am
entering data's in cell A, B and output to be displayed in cell C as follows
for eg:-
A B C
01/11/06 01/11/06 0
01/11/06 02/11/06 1
NA NA NA
01/11/06 NO Voilated
NO NO Voilated

Help Required
 

Thanks a lot friend.......:=(

"CLR" wrote:

Maybe this will do it for you.........

=IF(B1="NO","Violated",IF(AND(A1="NA",B1="NA"),"NA ",IF(AND(LEN(A1)=5,LEN(B1)=5),B1-A1,"")))

Vaya con Dios,
Chuck, CABGx3




"kiran" wrote:

Dear All,
I want macro or formula for the below mentioned querry pls help i am
entering data's in cell A, B and output to be displayed in cell C as follows
for eg:-
A B C
01/11/06 01/11/06 0
01/11/06 02/11/06 1
NA NA NA
01/11/06 NO Voilated
NO NO Voilated

Help Required
 

small change
A B C
01/11/06 02/11/06 1
NA NA NA
NO NO Voilated
01/11/06 NO Should show no for days instead of
Voilated
01/11/06 NA 1

TIA

"CLR" wrote:

Maybe this will do it for you.........

=IF(B1="NO","Violated",IF(AND(A1="NA",B1="NA"),"NA ",IF(AND(LEN(A1)=5,LEN(B1)=5),B1-A1,"")))

Vaya con Dios,
Chuck, CABGx3




"kiran" wrote:

Dear All,
I want macro or formula for the below mentioned querry pls help i am
entering data's in cell A, B and output to be displayed in cell C as follows
for eg:-
A B C
01/11/06 01/11/06 0
01/11/06 02/11/06 1
NA NA NA
01/11/06 NO Voilated
NO NO Voilated