Custom Calculation Script Assistance

[John5E59]

I have a formula in excell that calculates the numbers for me but I have been asked to convert it to a pdf format and I am not familiar with pdf calculations. Can anyone share with me the formula I need to calculate this?

I have a column that is labeled, "Drop (paig)", first box below is labeled, "Drop paigRow1". Beside that I have a  column labeled, "Pass", and the box below is labeled, "PassFailRow1". When someone types in the "Drop paigRow1" field a numeric character greater than  0.5, it will display, "Fail" in the "PassFailRow1" field. If the user types anything less than or equal to 0.5, it will display, "Pass" on the "PassFailRow1" field. 

Thanks in advance.

[Nesa Nurani · Accepted solution]

You can use this code in "PassFailRow1" field:

if(this.getField("Drop paigRow1").value > 0.5){
event.value = "Fail";}
else if(this.getField("Drop paigRow1").value <= 0.5){
event.value = "Pass";}
else event.value = "";

[John5E59]

It worked! Thank you Nesa. I hope you have a wonderful day!