Question about Business & Productivity Software
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.
Posted on Jul 18, 2008
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Oct 13, 2015 | Microsoft Excel for PC
Jul 29, 2009 | Business & Productivity Software
Sep 13, 2008 | Microsoft Business & Productivity Software
Aug 30, 2008 | Microsoft Excel for PC
Jun 18, 2008 | Business & Productivity Software
Dec 04, 2007 | Microsoft Excel for PC
Jan 16, 2017 | The Business & Productivity Software
173 people viewed this question
Usually answered in minutes!