Hi, Please put your questions into the body of the post. It causes problems in some web browsers. In Excel 2003 you can do 7 levels of nesting and in 2007...

value of $21,480 and gain/loss of $4,080 to currency style format with decimal poistions in excell

Dear Expert, I need to vlookup following items and match the fields ... Basically, this task is easy and straightforward. However, system generated file will...

I was under the impression that excel 2007 allowed more than 7 nested finctions or up to 64, but I continue to get an error that says "..........uses more...

Hello every one, I got this array: {0,0,1,1,0,1,1,0,1,1,1,1} Is there a way to SUM every 3 numbers? Desired result: SUM (0,0,1) SUM (1,0,1) SUM (1,0,1) SUM...

Problem- Excel not recognising or counting values between '0.01 to 0.99' in cells containing formula. My worksheet- A B C D ...

I am trying to create formula in cell L2 that reflectes 3 bids. The formula I am use works at 2 levels not 3. This is the formula I am using...

How do I turn off the automatic 'virus check' that runs each time I open an Excel file? Thanks.

Problem- Excel not recognising or counting values between '0.01 to 0.99' in cells containing formula. Exact sheet can be downloaded at-...

gcotterl wrote... I've having difficulty following what parts of a formula are triggered if the result of each IF statement is...

Look in Excel help for the IF function. -- David Biddulph gcotterl wrote: I've having difficulty following what parts of a formula are triggered if the...

I created a small database using Excel, this file has been running for serveral months now without a problem. Today, I went to enter in information and in...

I'm trying trying to create a column of number in a pattern: 1,1,1,2,2,2,3,3,3 etc. When I use the drag and fill option to continue this pattern, it...

I have two columns of data, one being gender and the other being nationality. I want to count how many British males there are, I can get the formulas to...

Is there any way I can use the VLOOKUP function in Excel to pull in information from Access and make calculations off that info? It would be helpful if I...

I've experimented with the workbook.open method in VBA, but seem to be getting better results with the following code. I can't see that there is a setting...

I'm using a spreadsheet to report distrcit number for different areas. In each district there are individual spreadsheets for each store, and a master one...

Greetings: This question has been submitted in prior postings with no responsive reply. There is supposed to be a way for someone with excel to insert data...

hi. How can i multiply two columns and put result in one cell?In the example below i would want $110 to appear in cell A1 example units ticket 2 ...

Excel wants to give me the XIRR function, but that requires a specific data layout, which is not always appropriate. I want to calculate a Compounded Annual...