math

[Anon]

Hi i've got a php page it's kind of a library of parts, what i have is a form that you fill in partno, part name, description, unit price then you submit the form and it stores it in a mysql database, however what i want to happen is when you input the unit cost (what we buy it in for) it calculates the selling price and stores that in the mysql database. The formula for sell price is unit cost + square root of unit cost + 10% i'm looking for the code that will do this formula, thanks for your help, Martin

[Anon]

Hiya,

I'm not sure if the 10% is
(a) 10% of unit cost or
(b)10% of (unit cost + square root of unit cost)

so here's both:

(a)
$sellprice = round(($unitcost + sqrt($unitcost) + ($unitcost / 10)),2)

(b)
$sellprice = round(($unitcost + sqrt($unitcost) + ($unitcost + sqrt($unitcost))/10),2)

That's expressing them roughly the same as you did. You could make things a little more compact and faster if you like as follows:

(a)
$sellprice = round((($unitcost * 1.1)+ sqr ($unitcost)),2)

(b)
$sellprice = round((($unitcost + sqrt($unitcost)) * 1.1) ,2)

I'm just typing these as I think them, but they look ok!

Cheers,

Jack

[Anon]

Hey Jack, thanks for the help it works great, thanks again Martin

[Anon]

No Worries, Martin,

Glad to be of help!

Jack