percent

I have fought with this for an hour or two and would greatly appreciate any help. I have a document that I need the periods to be aligned, the need to be in percent format with two decimal places. Some of the numbers have negatives and others have not. All help I've found doesn't keep the...

Hello Everybody, I'll try my best to explain this complex situation. There is data in column A and Column D. Data in column A is account no and data in Column D is some % value. Each account can have multiple % (please refer table below for example) Now I am trying to write a code to see if the...

Hello All, I have a code that opens outlook and pulls data from cells to send an email. There are cells that contain a percent sign (%). I want that to be preserved when it transfers to email, but it doesn't. I've noticed it also does that with the ampersand(sp?) sign. I realize these are...

I am trying to do simple Format of cells to have it display one digit beyond the decimal for numbers that are smaller than 1, and then no decimal for >1. So it should return: 0.2% or 0.5% and 1%, 5%, 10% [>=1]±#%;±0.0%;"" doesn't work. Suggestions?

Hello, I am not at all familiar with excel, vaguely but anyways, The problem is: if a master's degree program has a 5% fail rate, it lasts 12 months and it starts with a cohort of 100 students, how many students are left at the end, students can only pass or fail. I am not looking for the...

Hello All, I have a spreadsheet with data about what information in a database has been reviewed or not (data is reviewed on a “page” by “page” basis, per subject).</SPAN> The data looks something like this:</SPAN> <TBODY> SITE #</SPAN> SUBJECT #</SPAN> VISIT NAME</SPAN> VISIT DATE</SPAN>...

Form type progress indicator requested. Could anyone code a progress indicator into the following (I'm having a heck of a time trying to decipher VB): Sub addComments() ' first we'll clear existing comments For Each cmnt In ActiveSheet.UsedRange.Cells cmnt.ClearComments...

Hi! I'm trying to create a table from 5 to 36 columns (months). Each column should add up to 100%. The problem is that in each column I want the distribution of “percentages” to be normally distributed. For instance in colum 7, I need 100% to be close to normally distributed over 7 rows (For...

I need to enter a formula that increases the value 1799 (F5) by 20%. Please help! I know it sounds silly but I have such a hard time wrapping my head around percentages =(

Hi, I have had a decent google and haven't managed to find an answer that suits my problem. I have created a pivot table with 2 columns of data (as an example). I have added a subtotal to the row of data which is just summing the row label. Like this example for a debtors report: Row Label...

I need for example 1,000,000 = 100% So i need if someone enters 500,000 in A1 then it will show 50% in B1 I am unsure how to put this formula together

I have a excel 2007 spreadsheet that works out a total of a customers order, how do I get it to give them a 5% discount. so if their total in B29 = £423 I would like b30 to give me the amount with the 5% discount deducted. Hope this make sense thanks in advance

So I have data which I'm recapping in a pivot table and I'm using show values as percent to total. The issue is that I have the data over multiple years and I'd like to compare the same months penetration year over year. As of now I have the months across the top and I have years on the...

I need a formula to work out a percentage increase from one cell to another for example. Cell A1 = 10 Cell A3 = 15 Cell A4 = 50% Thanks in Advance! :)

If i have A1 and i want to minus 30% off what would be the formula? Can anybody help please?

<P style="MARGIN: 0in 0in 10pt" class=MsoNormal><FONT size=3 face=Calibri>Background: (1) I have a (Windows Vista) 2007 Excel worksheet with 14 columns and 2,354 rows, for a total of 32,956 cells. The file’s size is 304KB. Alone, the file serves as our parts and price list for our wholesale...

I have a problem with percent of total in excel... ....................January.........February.......... March ........ Product Total .......... % of Total Toppings ...... $19,314 .......... $21,698......... $18,742...

Hi guys, I've been working on a project and have hit a little bit of a brick wall. I have many problems at the moment, but the following is the most important thing I have to deal with. If someone can do this I'll be amazed as I've asked so many people and no one has any idea how to go about...

Excel is my source document which contains my data. Word is my template with my bookmarks. I have created a macro in Excel which opens my template and populates my Word bookmarks. The problem I am having is my data in Excel is a percentage (out to 2 decimals) and when the bookmarks in Word are...

Dear All, I am using Access 2007 and am at best an intermediate user so please be detailed in your response. I have a pivot table where I show the top 10 customers based on the sume of open sales orders. The fields are Customer Name and Sales. I added another instance of Sales and have the...