4 Replies Latest reply on Jan 23, 2018 12:08 AM by JR_Boulay

    Trying to replicate an excel formula in a form

    Geiger-san Level 1

      Hello all,

       

      In Excel, I had a dropdown cell and then other cells throughout the page linked to item selected in the dropdown to change based on the selection.  In practice it's a simple IF THEN statement, however I'm having trouble replicating this in JavaScript.

      For example, if the dropdown box choices are (Gold, Silver, Copper), then I need a separate textbox to populate with (150,100,50) respectively, and then another separate textbox still linked to the dropdown choice to populate with (A,B,C) etc and so on throughout the page as needed, all hinging on the dropdown choice selected.

      This is what I used in Excel, is this possible to replicate?

       

        =IF($I$12="Gold",150,IF($I$12="Silver",100,IF($I$12="Copper",50,IF($I$12="________",0))))

       

      Any advice or direction would be appreciated.  Thank you.

       

      Eric