When using the "if" function on the function wizard, I'm having problems with penny rounding. I have three columns. Column 1 is a net figure, and column 2 is...

I am wondering if there is a template for pension fund analysis. I need to determing the probjected benefit obligation for a 100+employees over a period of 5...

Hi I have a spreadsheet of numerical values and I simply want to increase all values, in all cells, by 17.5%. Can anyone please tell me how to do this? Many...

How do I format a cell to show the percent in stead of decimal? I have C1/C2 in the total it give me the decimal 0.31 how do I make it show 3% instead? Thanks

Hi, I have a pivot report based on a query against a database. The query has 3 columns Gender, CntMale, CntFemale In the pivot report, I need to show the...

Anyone please! How do I write a formula that gives me the total after deducting %. Example if I have $25 and I need to deduct 14% and I need to show the total...

Hi I would like to know how to get percent of time? i.e. 30% of 12:00 or 70 of 11:00 and still able to sum up / add-up the total results...

How do i get a figure for Percentage in xl? I have a set of cells that i need to know the percentage of. For example: Cell B6 to B 50 has names in it, what...

My formula is the following =SUM(F29/F10)*0.1 The percentage is coming out to 276%. I only want two decimal places (27%). Please help.

parker has 136 votes (d7) allen has 5059 (b7) webb has 4704(c7) if allen takes 66% of parker votes and webb takes 24% of parker votes what will parker have...

How do I show a percentage of one cell in $ in another cell also in $

I need to design a sheet that has along the top 1 - 50 (number of questions in the paper) and down the side has 1 - 50 (number of questions answered...

I have a sheet that I created with a whole number and I need to divide it in 4 different cells. For example: I have a number 100 in one cell. In four...

What function can I use/make to figure the difference in percentage between 2 monetary amounts?

Hello, in Excel 2000 how do I prevent Excel from multiplying percentage numbers by 100? In other words, if I type 5% in a cell, I do not want Excel to multiply...

This is what I have In cell D - 484 In Cell E - 526 Now in Cell E I want to display the percentage of increase (or decrease) The formula I currenty am using...

Hi, In my spreadsheet cell E14 adds up E2 - E14 and cell C14 adds up C2 - C14. In G14 I have put a formula to show the difference between E14 and C14 as a...

I have a spreadsheet with 3 columns of figures. There is a price increase of 6% this year but I don't know how to use the existing spreadsheet and add the...

In cell A10 I have the value of my shares at close yesterday (£1000 -cell formatted in £). In cell B10 have the value of my shares at close today (£1050 -cell...

I want to know the percentsge of completion of an Element, containing 7 items of % of completion, either as a completion rate of over 90%, and or...