To find a least value from 4 float fields

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Ashif Malayil
    Senior Member
    • Dec 2023
    • 171

    To find a least value from 4 float fields

    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
Working...