I use a website called Appizy to convert excel files to html/css/javascript. It generally works for my purpose as I am very proficient with excel and am usually able to tweak the final web based code through monkeying around with it or trial and error.
Below is the javascript code that was converted from an excel if/then statement.
s1r3c1: function() { APY.set('s1r3c1',formulajs.IF(APY.RANGE([1,3,0])=="x",formulajs.TRUE(),formulajs.FALSE())) },
};
In excel language I think this is saying that If a certain cell equals "X", then display True or False. Is there a way to tweak this to replace the "X" in this formula with a linked checkbox being turned on or off? I really have zero clue how to proceed. I am able to create a checkbox element in the HTML section of the code so it appears where I want it, but don't understand how to make it work.
I hope I have conveyed this clearly but if not, let me know and I will try to clarify. Thank you so much.