Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
13

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

New Here ,
Mar 14, 2024 Mar 14, 2024

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

appreaciated for the help in advance.

TOPICS
JavaScript , PDF forms
298
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
1 ACCEPTED SOLUTION
Community Expert ,
Mar 14, 2024 Mar 14, 2024
var a = Number(this.getField("A").valueAsString);
if (a>=0.01 && a<=0.3724) event.value = "X";
else event.value = "";

View solution in original post

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Mar 14, 2024 Mar 14, 2024
var a = Number(this.getField("A").valueAsString);
if (a>=0.01 && a<=0.3724) event.value = "X";
else event.value = "";
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Mar 14, 2024 Mar 14, 2024
LATEST

thats awesome!!

you save my day!

thank you

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines