Checkbook calculations

I am trying to create an Excel worksheet to calculate my checkbook. I want to be able to enter different transactions and have them added or subtracted from my balance, as well as keep a running balance. Any info will be most helpful. Thank you

Count function seeing formulas as data

How can you get around the count function seeing formulas in any cell referenced as data?

xdate in Windows 7

I finally entered the world of Windows 7, albeit only because my laptop died. I am a historan who needs to calculate dates into the 18th century. Xdate always worked just fine in Excel 2003, but when I load it into the new computer, Windows 7 sees it as an old process and refuses to recognize it. I need those date calculations, and I'm not thrilled with buying a later version of Office - if it even is in the newer versions - because A) I don't otherwise need it, and B) I've seen the recent version of Office and want no part of it.

Complex AND OR Formula

HI I need to express something in a formula , and am having trouble with it. I need to say this : IF E2 CONTAINS "1bx" OR "2bx" OR "3bx" OR "4BX" AND J2 =11 THEN PUT 1 , OTHERWISE PUT J2 Can someone assist with some code to make this happen , please? Grateful for any help. Sorry for double post. Best Wishes

IS THERE A FORMULA TO CALCULATE THE DISTANCE BETWEEN DATES

Does anyone know of a formula that will calculate how many days are from one date to another? For example from March 30 to April 8. This is for the purpose of getting the average amount of days for processing. Your help is highly appreciated. I am using Exel 2003.

Trying to get this if statment to work

I have excel 2000. I am trying to get this formula to work. It does not give me any errors or anything It just will not return the number in the cell that it references Cell CJ44 has the formula Here is an example of the cells CJ44 formula CL44 has =IF((I44=0),0,INT((I44-10)/2)) (the value in their is 0) CK44 has =IF((H44=0),0,INT((H44-10)/2)) (the value in their is -1) CP44 (the value in their is Y) but I want it to fuction normally if their is nothing (blank) in cell CP44 So this is what I have written, but the value does not return to what I want it to be. =IF(H44=0,CL4

what tab for calculating percent and decimal?

I want to find the percent for each column. Which tab do I click to get the drop down choice for percent. I found it once and forgot to remember it. I also remember seeing the dropdown had decimal as well. I am just starting to explore using this for my grading system at school. Today is my first day exploring this site.

maintaining constant percentage

Am trying to construct formula in excel 2007 for maintaining a constant percentage. Example: company 1 has 1,000 shares. Company 2 wants to purchase 10% of company 1 and always maintain the 10% rate. Buying 10% more shares would give a total of 1,100 and their percentage would be less than 10%. What formula can be used to calculate this and would find out how many more shares they would need to purchase in the event company 3 purchases X shares.

Simplify Weighted Average Formula

I have a s/s that has the months of the year across the top and below 3 categories for each month and I want a weighted avg for each product. eg: A B C D E F G H I January February March etc. to Dec Days Oil Gas Days OIl Gas Days Oil Gas 6 12 200 4 5 180 7 8 300 formula: =(a1*b1+D1*E1+G1*h1)/(a1+d1+g1) Is there a way to simplify this? Thank in advance for any help. -- ferne

Totaling columns

I was so impressed with the wonderful responses and spot on answers to my first question on this site I thought I would give this one a try. I did try to research to find this on the site, but perhaps I am wording my search incorrectly. My question is: On my download I run a macro that I have set up do calculations on my worksheet. 1.Each time the report is ran it would have varying information and varying numer of lines. For each run of the report the columns below would a have the following in common, but again each run would have a varying amount of rows) 2. Col A will

Keeping Formulas Not Data

I input my formula, but would like to fill in the data later. How do I save the Formula without there being data. I am trying to create time sheet that will be filled out weekly so the data will change. I want the formulas to add hours etc. to be in the worksheet with or without the data. Help!!

Data Labels in Excel Pie Charts

How do I get the data labels to stay where I put them in pie charts. I have a series of pie charts set up and update the data they are based on monthly. I find that most of the time when I go to the pie chart, whether or not I have updated the source data, the labels will move and typically so that they are not able to be read, eg all of them at the top of the form with some on top of the other. Is there a way to freeze the data labels so that I dont have to keep reformatting? -- Thanks as always Marlaine

COUNTA or COUNTIF or COUNT

Trying to count the times "YES" occurs in column C3:C5 for each time "Bill" indicated in column B3:B5? -- Thanks - liz

Exported data from Banner database to Excel

When I take a Banner database exported to excel and save it as .dbf file to use in mailing software, it drops certain fields in the name field. Does anyone know why this happens, is there some thing in those fields that is hiding the information? I causes great grief as the addressing software will shift all the data from the remaining fields up and totally mess up the name to proper address. Help?

Formula to pull the lowest supplier name

I need assistance creating a formula to extract the supplier name associated with the lowest supplier bid. A sample of the data looks like this. I need to be careful as some quotes will be zero and I do not want to pull this as the minimum supplier. Sup A Sup B Sup C Minimum Sup Bid Minimum Sup Name $/lb. $/lb. $/lb. $/lb. Item 1 1 2 3 1 ? Item 2 0.5 0.2 0.4 0.2 ? Item 3 2.4 1.9 0.8 0.8 ?

Counting question

In column A I have set of characters that are entered into the rows below (i.e. Y, N, MRO) in column B I have another set of characters that are entered into the rows below (i.e. A, E, on so on). I want to count the instances when the rows in Column A contain a Y and the rows in column B contain an A. Is there an simple formula for doing this? Any help will be appreciated. -- John

How to tell COUNTIF to not count a few characters

Im working on a colum that is a medical schedule for Doctor who will be working that day so that I know how many exam rooms will be needed - right now Im working with: =COUNTIF(F14:F43,"*") which tells me how many cells are not blank. But I would like to have countif not count cells in that same colum who have values like: OFF, ADMIN, OFF SITE and etc. Am I using the correct function? PLEASE HELP!

Count number of instances

Need a formaula to look at an entire column and count the number of different times (say date of product) Thanks -- ce

calculate equated monthly installment ?

How do we calculate equated monthly installment value for given int rate and period for a capital available and reverse of the same. Thanks

MEDIANIF

Was this function removed from 2007 or do I just need to download an add-in?

AMVERAGIF Condition

I am having trouble adding an AND statement to the condition portion of the AVERAGEIF statement. Is there a trick to doing this?

How can i protect a formula and still allow copy and move data?

i have 12 columns with data on days and each new day i want to add a new day to the set of 12 columns without adding a 13th one. So the oldest day are removed and the view is still 12 days. In these columns some values are calculated with formulas from data residing in the column (not from other columns) and i want to protect the formula but allow the column to be moved one step to the left. As of now i havent been able to use the built in functions of protection of cells and protection of formulas. Any ideas?

How to give a string of data into different columns

Super expert, If I have cell containing a series of data like this .... 1,12,9 1,2,9 1,22,17,18 23,23,1,9 24,21,1 1,23,11 22,1 2,3 Is it possible to use function or command to split them into columns? 1 12 9 1 2 9 1 22 17 18 23 23 1 9 24 21 1 1 23 11 22 1 2 3 I don't want to use "TEXT TO COLUMN" as some of the addresses can be overwritten. Thanks so much, Regards, Elton

vendor matches

This is my first question on this site, so I hope I hope this makes sense. I have vendor numbers in Col A-each vendor number would only be listed one time and not in numeric order. In Col B-- I assigned a number beside each vendor number in Col A. In column G, the same vendor numbers are listed but they may be listed more than one time and not in order. What I would like to do in Col H is if Col G has a match in Col A, I would like it to put the corresponding number from Col B in Col H. (Vendor#) (Vendor#) Col A Col B Col G Col H 123411 1

Size of file with pivot table

I have a file that was 8MB when I started. I created a pivot table pulling 7 fields from a worksheet. Now the size is 20MB. Any ideas why this one pivot table would cause the file to be so large when the 8MB file already had pivot table sin it? When it was 8MB, it had 6 pivot tables. Now it's 20MB and it has 7 pitvot tables. Why is this one table so much larger?