Scribd
Upload
8 views2 pages

Regional Data Analysis for B5 and B6

The document contains a series of conditional statements that evaluate combinations of values in cells B5 and B6 to return specific numerical values. It categorizes locations based on different criteria, assigning scores depending on the region and classification level. The conditions are structured using logical functions such as AND and OR to determine the output based on the specified criteria.

Uploaded by

D3ATH G4MING
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
8 views2 pages

Regional Data Analysis for B5 and B6

The document contains a series of conditional statements that evaluate combinations of values in cells B5 and B6 to return specific numerical values. It categorizes locations based on different criteria, assigning scores depending on the region and classification level. The conditions are structured using logical functions such as AND and OR to determine the output based on the specified criteria.

Uploaded by

D3ATH G4MING
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

AND(B5="I", OR( B6="Gubat",B6="Malilipot",B6="Bacacay",B6="Rapu-

rapu",B6="Manito",B6="Virac",B6="Malinao",B6="Tabaco",B6="tiwi",B6="Goa",B6="Tinamb
ac",B6="Cauayan",B6="Ilagan",B6="Tuguegarao")),320,

AND(B5="II", OR( B6="Gubat",B6="Malilipot",B6="Bacacay",B6="Rapu-


rapu",B6="Manito",B6="Virac",B6="Malinao",B6="Tabaco",B6="tiwi",B6="Goa",B6="Tinamb
ac",B6="Cauayan",B6="Ilagan",B6="Tuguegarao")),310,

AND(OR(B5="III",B5="IV",B5="V"),
OR( B6="Gubat",B6="Malilipot",B6="Bacacay",B6="Rapu-
rapu",B6="Manito",B6="Virac",B6="Malinao",B6="Tabaco",B6="tiwi",B6="Goa",B6="Tinamb
ac",B6="Cauayan",B6="Ilagan",B6="Tuguegarao")),300

AND(B5="II", OR( B6="Legazpi",B6="Sto.


Domingo",B6="Daraga",B6="Guinobatan",B6="Jovelar",B6="Ligao",B6="Polangui",B6="Naga
",B6="Iriga",B6="Sipocot",B6="Sorsogon
City",B6="Barcelona",B6="Irosin",B6="Matnog",B6="Bulusan",B6="Casiguran",B6="Juban"
,B6="Bulan",B6="Buhi",B6="Daet",B6="Cam
Sur",B6="Quirino",B6="Santiago",B6="Cagayan")), 300,

AND(OR(B5="III",B5="IV",B5="V"), OR( B6="Legazpi",B6="Sto.


Domingo",B6="Daraga",B6="Guinobatan",B6="Jovelar",B6="Ligao",B6="Polangui",B6="Naga
",B6="Iriga",B6="Sipocot",B6="Sorsogon
City",B6="Barcelona",B6="Irosin",B6="Matnog",B6="Bulusan",B6="Casiguran",B6="Juban"
,B6="Bulan",B6="Buhi",B6="Daet",B6="Cam
Sur",B6="Quirino",B6="Santiago",B6="Cagayan")), 290

AND(B5="I", OR( B6="Pilar",B6="Donsol",B6="Pio-duran",B6="San Fernando/Ticao


Island",B6="Aurora",B6="Kalinga",B6="Apayao")),300
AND(B5="II", OR( B6="Pilar",B6="Donsol",B6="Pio-duran",B6="San Fernando/Ticao
Island",B6="Aurora",B6="Kalinga",B6="Apayao")),290

AND(OR(B5="III",B5="IV",B5="V"), OR( B6="Pilar",B6="Donsol",B6="Pio-duran",B6="San


Fernando/Ticao Island",B6="Aurora",B6="Kalinga",B6="Apayao")),280

AND(OR(B5="III",B5="IV",B5="V"),
OR( B6="Gubat",B6="Malilipot",B6="Bacacay",B6="Rapu-
rapu",B6="Manito",B6="Virac",B6="Malinao",B6="Tabaco",B6="tiwi",B6="Goa",B6="Tinamb
ac",B6="Cauayan",B6="Ilagan",B6="Tuguegarao")),300

AND(B5="I", OR( B6="Masbate",B6="Quezon",B6="Rizal",B6="Carranglan",B6="Nueva


Vizcaya",B6="Ifugao",B6="Mountain Province",B6="Ilocos Norte")),290

AND(B5="II", OR( B6="Masbate",B6="Quezon",B6="Rizal",B6="Carranglan",B6="Nueva


Vizcaya",B6="Ifugao",B6="Mountain Province",B6="Ilocos Norte")),280

AND(OR(B5="III",B5="IV",B5="V"),OR( B6="Masbate",B6="Quezon",B6="Rizal",B6="Carrang
lan",B6="Nueva Vizcaya",B6="Ifugao",B6="Mountain Province",B6="Ilocos Norte")),270

AND(B5="I", OR( B6="Padre


Burgos",B6="Tayabas",B6="Lucban",B6="Sampaloc",B6="Magdalena",B6="Laguna",B6="Rizal
(Antipolo)",B6="Bulacan",B6="Gapan",B6="Cabanatuan",B6="San
jose",B6="Benguet",B6="Abra",B6="Vigan")),280

AND(B5="II", OR( B6="Padre


Burgos",B6="Tayabas",B6="Lucban",B6="Sampaloc",B6="Magdalena",B6="Laguna",B6="Rizal
(Antipolo)",B6="Bulacan",B6="Gapan",B6="Cabanatuan",B6="San
jose",B6="Benguet",B6="Abra",B6="Vigan")),270

AND(OR(B5="III",B5="IV",B5="V"),OR( B6="Padre
Burgos",B6="Tayabas",B6="Lucban",B6="Sampaloc",B6="Magdalena",B6="Laguna",B6="Rizal
(Antipolo)",B6="Bulacan",B6="Gapan",B6="Cabanatuan",B6="San
jose",B6="Benguet",B6="Abra",B6="Vigan")),260

AND(OR(B5="III",B5="IV",B5="V"),OR( B6="Masbate",B6="Quezon",B6="Rizal",B6="Carrang
lan",B6="Nueva Vizcaya",B6="Ifugao",B6="Mountain Province",B6="Ilocos Norte")),260

You might also like