convert Excel formula to JavaScript

amwith · #1 (**permalink**) March 6th, 2008, 12:34 PM

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

joefawcett · #2 (**permalink**) March 6th, 2008, 01:03 PM

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

Code:

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

--

Joe (Microsoft MVP - XML)

amwith · #3 (**permalink**) March 6th, 2008, 01:50 PM

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.

joefawcett · #4 (**permalink**) March 7th, 2008, 06:31 AM

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

Code:

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

The variable 'result' holds the correct value, you need to put that into your column.

--

Joe (Microsoft MVP - XML)

Need to download code?

Navigation