I have 13 worksheets titled Jan - Dec and Total. Each of the Jan - Dec worksheets are set up identical but after each month, different data is entered for...

All I want to do is have my phone numbers appear (555) 555-5555, but for some reason I keep getting all these weird -- in between the numbers. I read that I...

Help for the needy... please? Am trying to make a wildcard IF formula to work. The sample below doesn't work because IF formula can only match by one word and...

Hi, I'm trying to create a formula based on a minium order qty (MOQ) for example cell a1 would have the MOQ figure, b1 would have an opening stock figure,...

can any one help me to using lookup function with more then one condition,

I am trying to setup an external reference using the offset function, as in: =OFFSET('\\file_path\worksheet'!$CR$20,0,0) Ultimately this will help me...

I am unable to create a file showing multiple subtotal levels using Excel 2003. I previously used this function in all versions prior to Excel 2003. I create...

I know that I can manually go in to a formula and put a "$" to anchor a cell (i.e., create an absolute reference), but I remember there being a way that...

I'm running a vlookup on a list of customer accounts to find what store is closest to the customer by zip codes. However, for every single customer, my formula...

I am trying to calculate a number using =sum(D5*4)+B55, but one of the cells contains the the word "included". It's a pricing model, so it's important to note...

Can anyone tell me what's wrong with this formula: =IF(D5=517,8,IF(D5=520,8,IF(D5=521,8,IF(D5=522,8,IF(D5=523,8,IF(D5=524,8,IF(D5=567,8,IF(D524,0,D5)))))))) I...

I have created a form in Excel that is to be filled in by end users. This form spans several worksheets. On each worksheet there are several input fields that...

SUMIF allows one to enter a criteria text string into cell D2, say "14000", and then reference D2 as the function criteria,...

Hello all!! I am trying to do a macro that will look for a number in column A and then replace the contents in column c with a 15. Example A B ...

I am trying to build a formula that will fill a cell with the value from a table if certain conditions exist in another adjacent cell. I tried to use the IF...

HOW WOULD I TAKE INFORMATION FROM ONE MAIN WORKSHEET AND HAVE IT AUTOMATICALLY BE COPIED TO DIFFERENT WORKSHEETS? I'M IN THE CONSTRUCTION BUSINESS AND I NEED...

I am building a spreadsheet with groups of 2-8 rows merged in column A. Is there a way to insert a conditional page break if a specific group of merged cells...

I can't figure out where have I gone wrong with this formula: =IF(VLOOKUP(GlobalOpsInput!$B$25,RefTables!$A$130:$B$133,2,FALSE),"Ops Plant Engineer -...

Hi, I have made a Pivot Table (with 4000 rows and 80 columns) giving details of Employee Expenses for 2005-06 but it has columns which have similar...

I have a two colums with values, A contains numbers from 1 to 10, B contains numerique values. Now I would like to make the sum of the values in B depending on...