IF Function with Less Than Values

4 replies
619 views
Translate

How do you formulate an IF function where if the value of Field "C" is less than 70,000, then the value of Field "Tier 2" is not formulated?

Right now, this is what I have:

event.value = (70000-this.getField("C").value)*0.2;

if(C<70000)event.value,"Not Commissionable"

I know this isn't correct as I am not a professional with Javascript or Advanced Calculations, but I would like to know how to do this.

Thank you!

This topic is closed to new replies. Start a new post to keep the conversation going.

try67Correct answer

Community Expert

Almost... Try this:

var C = Number(this.getField("C").valueAsString);
if (C<70000) event.value = "Not Commissionable";
else event.value = (70000-C)*0.2;

try67

Correct answer

Community Expert

Almost... Try this:

var C = Number(this.getField("C").valueAsString);
if (C<70000) event.value = "Not Commissionable";
else event.value = (70000-C)*0.2;

Translate

masonb77741322Author

Participating Frequently

Even though the value "Not Commissionable" didn't populate (not your fault as I was just testing the software), thank you for your response! Your formula worked for what we needed it for!

Translate

try67

Community Expert

Make sure you set the field's Format to None for it to work.

Translate

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.