I found a web site that converts Excel worksheet to HTML.

First, I wanted to know if this code is javascript:

var c1C21=(((var_ls((c1C19),(5)))?(((v2n(c1C19))+(5))) :(((v2n(c1C19))-(5)))));

Second, is their a way to convert the above line to an Excel formula?

What does the var_ls and v2n represent in the above line?

Thanks

Hi there,

Pretty hard to tell by this code alone. You can simplify it to this:

var c1C21 = var_ls(c1C19, 5) ? v2n(c1C19) + 5 : v2n(c1C19) - 5;

This says something like:

If var_ls(c1C19, 5) is null, then take v2n(c1C19) - 5, otherwise, take v2n(c1C19) + 5

I can only assume that var_ls and v2n are functions defined somewhere in your HTML page or JavaScript file.

Cheers,

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!

Thanks for your reply!!

The code was taken from a web page source code.

The code was generated by a program using spreadsheet converter.

I was curious to know what the Excel formula was that was translated to javascript.

If you have any suggestion.

Thanks

Again, hard to tell without seeing the code or original spread sheet. It might have been something like this:

=IF(ISBLANK(B7), B8 - 5, B9 - 5)

Cheers.

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!

Maybe the Excel formula may be:

var c1C21=(((var_ls((c1C19),(5)))?(((v2n(c1C19))+(5))) :(((v2n(c1C19))-(5)))));

var_ls might be the equivalent to MOD?

Not sure what v2n may be

Possible formula ==IF($C$19<5,$C$19+5,$C$19-5)

Thanks again!!