I am not Excel savvy. I am creating a simple spreadsheet to calculate the application of annual salaries and benefits to contracts based upon that contract's percentage of total revenues. I have entered total contract revenues, the number of months the contract is active in 2010, the number of months the contract is active in other years, then used a formula to calculate the percentage of the contract revenues applicable to 2010. I have the percentages expressed in whole numbers as I want to keep this "broad brush strokes." All that works fine. However, I then want to express those "round number" percentages in terms of dollars by using formulas. However, when I do that, Excel calculates the dollars using precise percentages (for example, using 54.55%) rather than the whole number percentage (55%). I have attached a portion of the spreadsheet to illustrate the formulas I am using. Can someone please help me use formulas to express the dollars using whole percentage numbers rather than the (actual) fractional percentages? THANK YOU!!!
Bookmarks