Hi, I am new to this forum and very new to javascript. We are trying to make an easier process for the company to receive material pricing from our suppliers. At the moment, we receive hand written garbage that is quoted in either price per pound, price per foot, or each.
I am trying to create an easy to use form to eliminate all the extra calculation work.
I tried to attach an excel file that does EXACTLY what I am looking to do but it wont let me. I attached a pdf of the excel sheet to try to explain what it does The "Total" column has this code in it..
=IF(H3="PER FOOT",G3*E3*A3,IF(H3="PER POUND",G3*F3*A3,G3*A3))
Basically all I am trying to do is convert different pricing back in a price per piece (EACH PRICE). Simple calculations between cells is no problem, just the "if" code.
The only thing I need help with is coming up with a code that will do this. I am familiar with coding but have never touched javascript and for the simplicity of this code I was hoping somebody could just help me instead of going through hours of learning.
Please have a look at the attached filed and if anyone can help it would be extremely appreciated!
Thanks
Sandro