Ruth Davies
New Member
- Joined
- Feb 2, 2005
- Messages
- 1
Hi
I have 6 cells:
A1 = Case Number
B1 = Date of Hearing
C1 = Type of Case (V or N)
D1 = Date Information Faxed
E1 = In Target (Y or N)
F1 = Enter Reason
There are two types of cases V = Vulnerable and N = Non Vulnerable, Vulnerable cases need to have information faxed within one day from the date of Hearing and Non Vulnerbale Cases within three days of the date of hearing to be within Target (for eg. Date of Hearing today 02/02/05 then Vulnerable case out of target if information faxed 04/02/05). Therefore if a user inputs the data we require and the sum of cells (D1-B1) are greater than one (v) or three dependant on the case type, how can i FORCE the user to "enter a reason"
All I managed to do so far is enter into cell E1 the following formula:
IF(AND(C1="V",(D1-B1)>1),"enter reason",IF(AND(C1="N",(D1-B1)>3),"enter reason",""))
This alerts the user to insert a cooment into cell F1 BUT DOES NOT FORCE THEM TO DO THIS
If anyone can help me it would be appreciated
Ruth
I have 6 cells:
A1 = Case Number
B1 = Date of Hearing
C1 = Type of Case (V or N)
D1 = Date Information Faxed
E1 = In Target (Y or N)
F1 = Enter Reason
There are two types of cases V = Vulnerable and N = Non Vulnerable, Vulnerable cases need to have information faxed within one day from the date of Hearing and Non Vulnerbale Cases within three days of the date of hearing to be within Target (for eg. Date of Hearing today 02/02/05 then Vulnerable case out of target if information faxed 04/02/05). Therefore if a user inputs the data we require and the sum of cells (D1-B1) are greater than one (v) or three dependant on the case type, how can i FORCE the user to "enter a reason"
All I managed to do so far is enter into cell E1 the following formula:
IF(AND(C1="V",(D1-B1)>1),"enter reason",IF(AND(C1="N",(D1-B1)>3),"enter reason",""))
This alerts the user to insert a cooment into cell F1 BUT DOES NOT FORCE THEM TO DO THIS
If anyone can help me it would be appreciated
Ruth