Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Required fields in Excel | New Users to Excel | |||
can you make a cell value required? | Excel Discussion (Misc queries) | |||
highlighting required fields | Excel Worksheet Functions | |||
SPECIFY REQUIRED PAPER SIZE IN EXCEL 2000 | Excel Discussion (Misc queries) | |||
Rate of return required formula | Excel Worksheet Functions |