Quote:
Originally Posted by KarTek
You have to kind of translate programming formula's into spreadsheet cells. You can think of every cell in the sheet as a variable. The names just happen to be "A4" and "GG6".
Now, you can put a number or a formula or a logic statement into a cell then you can use that cell number as part of another equasion in another cell and on and on.
So, in a cell type "New Server Cost". In the cell adjacent to that, enter 114196.00. Then, you can incorporate the label of the cell with the "114196.00" in it into other formulas on the same sheet or other worksheets. So, let's say that the label of the cell with the number in it is "F5". Any time you want to use the 114196.00 in an equasion, you simply substitute "F5".
If you have a crossloop setup, I can link to your computer and show you directly.
|
So what I understand is that I cannot assign a cell to just equal a variable name then?
Cell C3 = 114196.00
Cell C4 = newServerCost
so, on my second sheet if I'd like to show the cost for 4 servers I'd use
what yak and you mentioned
call sheet1 or what I have it as variables then multiply what I have in C3 by 4 on my sheet for virtulized like so
variable!C3*4
si?
then I can do whatever arthimatic I'd like then?