Question about Computers & Internet
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 Technician 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 repair professionals here in the US.
click here to Talk to a Technician (only 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
Sep 22, 2009 | HP LaserJet 4240n Printer
Jul 29, 2009 | Computers & Internet
Sep 13, 2008 | Microsoft Computers & Internet
Aug 30, 2008 | Microsoft Excel for PC
Dec 04, 2007 | Microsoft Excel for PC
176 people viewed this question
Usually answered in minutes!