Quote:
Originally Posted by TheDon
So, there is no way in Excel to assign the variables in my variables sheet an integer value? I cant stop thinking how to do it in C or Java, if you know what I mean.
I just want to do
newServerCost = 114196.00
(for example)
then be able to use that in my other sheets to perform math on.
|
If all you want to do is have the variables visible in every sheet, a simple copy and past ought to do that. Highlight the relevant cells on sheet 1, paste them into sheets 2 and 3. You should see a number (integer) in the spreadsheet itself, but a reference to the location of the original number will be in the field above the table.
If you only want to paste the integer value, copy, then navigate to where you want to paste, right click, select "paste special", select "values" and that will only paste the current integer value of the copied cell into the pasted cell. This is useful for copying info from one file into another file. If you try to paste across files you can get errors or broken links.
I'm not sure I follow your example exactly, but putting an = in the beginning of a cell value tells that cell you're going to do something to it. When you say power (fixed number?) in A4 and variable in A5, all you need to do to multiply the constant times the variable is type in a different cell =A4*A5. If A4 is on sheet 1, that becomes =sheet1!A4*A5.
Think of each cell on each sheet as an address or location. The software assumes the cell is on the same sheet unless you tell it otherwise. =locationX[some math function]locationY should get it done.
I've done a mini template. Notice the sheets are named for the info on them. This affects the reference names. Sometimes it's a helpful touch if you're navigating through different items. I added a roundup function reference since you can't buy a fraction of a server. Excel, when used properly can be pretty powerful but you have to learn the quirks.