Simple calculation using script written in Google Sheets

Question

I am really new to calculations in html/js. A colleague gave me a script written in Google Sheets and I am trying to implement it into a html calculator I have created. Here is a simple example (the full script will calculate many inputs when a button is cliked) of what I am trying to do:

The html:

<input type="text" id="A" value="2"> X
<input type="text" id="B" value="5">
<input type="button" onClick="calculate()" value="Calculate"> = 
<output id="total"></output>

Script:

function calculate() {
    var A = document.getElementById("A").value;
    var B = document.getElementById("B").value;
    var total = A*B;
};

I know this is probably terribly wrong, but I am learning :)

Codepen example

T K · Accepted Answer · 2018-08-01 10:56:20Z

2

You aren't assigning the calculated value to the DOM.

Working Example:

function calculate() {
    var A = document.getElementById("A").value;
    var B = document.getElementById("B").value;
    var total = A*B;

    document.getElementById("total").value = total;

};

<input type="text" id="A" value="2"> X
<input type="text" id="B" value="5">
<input type="button" onClick="calculate()" value="Calculate"> = 
<output id="total"></output>

answered Aug 1, 2018 at 10:56

T K

6281 gold badge7 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Simple calculation using script written in Google Sheets

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related