May someone help me solve this. i would really appreciate it. thanks! =IF(AND(A4
ID: 3594012 • Letter: M
Question
May someone help me solve this. i would really appreciate it. thanks!
=IF(AND(A4>0,A4<1369),””,”Error: Values must be between 1 and 1368”)
=IF(OR(G8=”C”,G8=”G”,G8=”L”,G8=”P”),””,”Error: Invalid plane code”)
Reasonable Test
Validity Check
Closed-loop verification
Field Check
Sign test
Range Check
- a. b. c. d. e. f. - a. b. c. d. e. f.=IF(AND(A4>0,A4<1369),””,”Error: Values must be between 1 and 1368”)
- a. b. c. d. e. f.=IF(OR(G8=”C”,G8=”G”,G8=”L”,G8=”P”),””,”Error: Invalid plane code”)
- a. b. c. d. e. f. - a. b. c. d. e. f. - a. b. c. d. e. f. a.Reasonable Test
b.Validity Check
c.Closed-loop verification
d.Field Check
e.Sign test
f.Range Check
Explanation / Answer
Six records
1st record - Instead of september 1, it has been entered wrongly as september 10.
2nd record - The member number is 1368 but it is entered as 4111 which is greater than it.
3rd record - it is quite perfect
4th record - The entered code for the plane id not valid, because it is given as C, G, L, P
5th record - In this record, the member number contains 'A' - 012A, which is not valid
6th record - The take off time is given as 15:31, which is more earlier than the landing time as 13:45
Types of application and it controls
Member# - 1st Field
Flight Date MM/DD/YY - 2nd Field
Plane Used - 3rd Field
Takeoff Time - 4th Field
Landing Time - 5th Field