Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I calculate my aluminum can pounds for quick reference?
I had a friend make me a chart that reads 1 lbs at $.35. And then it
calculate by itself all the way to about 300 lbs. Can someone tell me how to change it to $.30 a lbs and it recalculte or how to make a new one. Thanks |
#2
|
|||
|
|||
In A1 type .3 and format as currency In A2 type 1 and in A3 type 2. Now highlight A2:A3 and drag fill down as far as you want to go (300?). In B2 type: =A2*$A$1 Now drag copy B2 down the same number of cells as you went in column A You will now be able to get the prices for the weights and if the base price changes you just have to change the value in A1 -- Cutter ------------------------------------------------------------------------ Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848 View this thread: http://www.excelforum.com/showthread...hreadid=472794 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Spreadsheet Won't Calculate | Excel Discussion (Misc queries) | |||
calculation of pounds per hour | New Users to Excel | |||
Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
Convert Numeric into Text | Excel Worksheet Functions | |||
Spellnumber | Excel Worksheet Functions |