Let's start with the 1st equation. I assume you want to be able to recalculate by changing the number of pages.
Put 65 in cell a1.
360 in b1
In C1, put the formula =a1/b1 that's your book thickness
In D1, put .02 for the cover
In E1, put the formula =C1+D1
Now you can change A1, B1,or D1 and the Total thickness gets recalculated automatically. Be careful not to type numbers into C1 or E1, or you lose the formula.
The same for the other equations - a cell for each number ("variable") and another cell for calculations.
Once you've verified the results, then you can get fancy and add titles above each field to make it easy to remember what goes where.
You may need to change the cell format to control the number of decimal places, or thousands commas. Right click on a cell and select format to see the choices you have.
Keep a backup copy of the spreadsheet in case someone (not you, of course) makes a mistake and overwrites the formula cells. You can also look into "protecting" cells to keep them from being changed.
Hope that helps.
201 views
Usually answered in minutes!
All-in-One Excel Functions and Excel Formulashttp://atips4pc.blogspot.com/2012/02/all...
×