IF Function with Less Than Values

[masonb77741322]

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!

[try67 · Accepted solution]

Almost... Try this:

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

[masonb77741322]

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!

[try67]

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

[masonb77741322]

I changed "Not Commissionable" to "0" and it's formulating exactly how I need it to.

Thank you again for your help!