#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 65
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 65
Default 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

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 65
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Required fields in Excel [email protected] New Users to Excel 5 November 4th 10 06:33 PM
can you make a cell value required? nishapurohit Excel Discussion (Misc queries) 2 January 31st 06 12:42 AM
highlighting required fields maryann Excel Worksheet Functions 2 June 23rd 05 06:16 PM
SPECIFY REQUIRED PAPER SIZE IN EXCEL 2000 Augustine Excel Discussion (Misc queries) 0 January 17th 05 01:05 PM
Rate of return required formula Alorasdad Excel Worksheet Functions 1 November 18th 04 04:14 AM


All times are GMT +1. The time now is 05:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"