Skip to main content
Participant
March 14, 2024
Answered

Need help on writing this formula from Excel on a pdf form

  • March 14, 2024
  • 1 reply
  • 360 views

=IF(AND(cell a>=0.01,$call a<=0.3724),"X","")

appreaciated for the help in advance.

This topic has been closed for replies.
Correct answer try67
var a = Number(this.getField("A").valueAsString);
if (a>=0.01 && a<=0.3724) event.value = "X";
else event.value = "";

1 reply

try67
Community Expert
try67Community ExpertCorrect answer
Community Expert
March 14, 2024
var a = Number(this.getField("A").valueAsString);
if (a>=0.01 && a<=0.3724) event.value = "X";
else event.value = "";
Participant
March 14, 2024

thats awesome!!

you save my day!

thank you