I am trying to take an input value and round it up to the nearest whole 5 and then use that new value in an IF formula. However there is some detail I am getting incorrect as when the rounded value is outside of the parameters it returns the result anyway. Please where did I go wrong.
var SST = Number(this.getField("SST").value); var SLT = Number(this.getField("SLT").value); var SCT = Number(this.getField("SCT").value); var Ref = this.getField("Ref").valueAsString;
I tried every iteration I could think of to get this to work and I swear I had to have tried that. You must be one of the people that nothing works until you show up and just by being there everything works.