I'm trying to convert the following Excel formula to JavaScript:

=IF(C6>=500, C6*0.9,"")

I am trying to take the total of one column (C6) and if it is greater than 500, multiply it by .90 (and put that quantity in a new column).

I am creating a fillable pdf in Adobe Acrobat that will do calculations. It requires some JavaScript.

thank you

The JavaScript equivalent is the ternary conditional operator:
expression ? when true : when false. So --

Joe (Microsoft MVP - XML)

Thank you for your quick response. when I put the following in, I am getting a syntax error.

var C6 = <value in cell C6>;
var result = (C6 >= 500) ? C6 * 0.9 : ""

if (C6>=500) {
    C6 * 0.9 : "";
  }

I am just learning JavaScript so it may be something very basic and simple. Thank you for your time.

The items delimited by <> are meant to be replaced by your code, I can't tell how you get the initial value of cell C6 into a variable.
You don't need
The variable 'result' holds the correct value, you need to put that into your column.

--

Joe (Microsoft MVP - XML)