how do I import excel functions to FrontPage

S

SLIPSTREAM

I want to make a website that has a form that uses basic excel functions such
as SUM and IF decision variables. More specifically, I want to use check
boxes and I want other values to change based on which check box is clicked
on. Thanks for any help!
 
T

Trevor L.

SLIPSTREAM said:
I want to make a website that has a form that uses basic excel
functions such as SUM and IF decision variables. More specifically, I
want to use check boxes and I want other values to change based on
which check box is clicked on. Thanks for any help!
Click to expand...

You need to write a javascript function.

It has many functions available to help

SUM would be done by looping around elements
An example
var sum= 0 , Lmax = 5
for (var L=1 ; L <= Lmax ; L++)
{sum += document.getElementByID("ident" + L).value }
return sum

IF functions are as simple as
if (var == value)
{ // do something
}

Have a look at http://www.w3schools.com/default.asp or many other sites
(Google for "Javascript")
 
M

MD Websunlimited

Hi,

The Excel function are not available in FrontPage or any web design package. To accomplish you'll need to program either the client
side or server side using a programming language.
 
S

SLIPSTREAM

WOW! That's totally what I want my site to do. I'm downloading the program
right now--if this works like I think it will, I will be very indebted to you
(developing this site is supposed to save my company a ton of $$$)

Thanks so much for the tip!!
 
M

MDBJ

happy to help.
you should also know the author is very good about letting you send him a
spreadsheet, and sending back a
version that will work with his converter.

he did this for me, full sheet, once before purchase, once since.. both
times in about a day.

I couldn't use one excel function, he showed me how to do the same thing in
another way
(I had an array-he sent me enough lines to finish the sheet in another
manner- going line by line)
check the list at
http://www.spreadsheetconverter.com/article/articleview/33/1/1/ for
supported
excel functions..
 
Top