var min = field1;
// Compare and find the minimum value
if (field2 < min) {
min = field2;
}
if (field3 < min) {
min = field3;
}
if (field4 < min) {
min = field4;
}
// Determine band score and eligibility based on the minimum value
if (min < 6) {
score = 0;
Eligibility = "Not-Eligible";
} else if (min == 6) {
score = 0;
Eligibility = "Eligible";
} else if (min == 6.5) {
score = 0;
Eligibility = "Eligible";
} else if (min == 7) {
score = 10;
Eligibility = "Eligible";
} else if (min == 7.5) {
score = 10;
Eligibility = "Eligible";
} else if (min == 8) {
score = 20;
Eligibility = "Eligible";
} else if (min > 8) {
score = 20;
Eligibility = "Eligible";
}
this formula is not working, any modification needed
// Compare and find the minimum value
if (field2 < min) {
min = field2;
}
if (field3 < min) {
min = field3;
}
if (field4 < min) {
min = field4;
}
// Determine band score and eligibility based on the minimum value
if (min < 6) {
score = 0;
Eligibility = "Not-Eligible";
} else if (min == 6) {
score = 0;
Eligibility = "Eligible";
} else if (min == 6.5) {
score = 0;
Eligibility = "Eligible";
} else if (min == 7) {
score = 10;
Eligibility = "Eligible";
} else if (min == 7.5) {
score = 10;
Eligibility = "Eligible";
} else if (min == 8) {
score = 20;
Eligibility = "Eligible";
} else if (min > 8) {
score = 20;
Eligibility = "Eligible";
}
this formula is not working, any modification needed