Excel Formula 12 per 1000

[pmidwest]

I am trying to set up a profit margin calculator in excel I want to be able to type in the quantity of say paper and then have the quantity of ink automatically change to a certain number... say I put 1000 in the paper quantity I would want the ink to change to 12. Basically 12 per 1000... Is this possible?
Any help would be greatly appreciated

Thanks

Paul

 

[onedtent]

if paper quantity is in A2, how about
=INT(A2/1000)*12

 

[pmidwest]

Thanks alot!!!