Jan 6, 2010
I'm brand new to this forum, so please forgive me in advance. I am hoping someone might be able to point me in the right direction. I got a request from my boss and it's something I've never done in Excel and far more advanced than anything I've tried to do.
View 14 Replies
In my spreadsheet, Columns B-BD are server names, and Rows 2-13 are program names. Inside the corresponding cells all have to display as percentages, and we are trying to display what percentage of each server is being used by each program. In Row 14, each column must total to be 100%. That part is easy, I already have that all setup.
However, the next step requires that each server is assigned a monetary value - one of two monetary values for Virtual or Physical server. Then, somehow I need Excel to calculate the monetary value for each percentage.
For example: if Column B is Virtual, and Row 14 totals up to equal 100%, it also equals $1,000. Say Cell B4 is equal to 50% and B5 is equal to 50%, each cell is also equal to $500. Easy enough in theory, but how should I execute this so that these cells stay in % format, but Column BE titled "Total Cost" displays the monetary value for each Program (row)?
I'm pretty sure there will be some kind of formula so I guess that's what I'm asking... how to calculate it?
I'll attach a screen shot to show you the gist of how it looks so far ...