This is probably really simple but here goes:
I have been asked to help convert a formula from an excel spreadsheet to work on a webpage.
I have to the best of my ability converted the logic of the spreadsheet into what I believe is PHP variables/code but have no idea how to integrate it in some html to allow someone to input a number - pass it to the PHP script, have the php script perform the calculation and then have the result returned to the webpage.
This is the PHP code I have created.
<?php
$vpg = 4.5;
$cpp = 0.35;
$wr = 35;
$vpexv = 100 /117.5 * $vpg;
$cpw = $customers * $cpp;
$tcpw = $cpw + $wr;
$cnpw = $customers * $vpexv;
$ppw = $cnpw - $tcpw;
$anp = $ppw * 52;
$ppm = $anp / 12;
?>
Basically, the $customers variable is what is taken as an input from the website, processed in the script above (not tested) and then returned to the webpage. Ideally I want a input box which someone can enter a number and click a button that says 'calculate' then the answer is returned.
If anyone can offer any help either with a working demo or pointing me in the right direction I would appreciate it very much.
