Hi, Wonder if anyone can help. I have a formula which is something like this: =IF(G3=0,"-",=big formula) where "big formula" is, erm, a big formula. ...

I have 20061030 in a cell that is formatted as general. How do I change this into date format like 10/30/2006? If I format cell and select date then it gives...

Dear Dave/Excel experts, I have errors doing SUMIFS function. Below are my tables: Category Code Amount ANA 100.01 $ 50 LPP ...

Hi All, How can I get a check box to return TRUE, in a cell of my choice Thanks Mike -- Mike

I have a spreadsheet and column C has words like suspended, authorised, pending etc - can I create a formula to total the different states?

Does anyone have a suggestion why a cell would display a number on the screen (result of a formula), but be blank for both "print preview" and printing to a...

I am using recently upgraded Excel 2007 (from 2003 version), and entering names into a list. A quick review of the column containing names showed a typo...

I have a spreadsheet with several sheets. There is also a macro. When I answer the macro security option question "enable this content", the tabs for sheet1...

I have been searching forums and trying formulas for 6 hours and I still can't make this work. I have this table (below) and I want to know how many orders...

I want to create a spreadsheet that shows a list of files, and their thumbnail images in a column of cells. I am using Excel 2007 These files are drawings...

Hello. Opposite to EXCELL 2003 if seems that EXCELL 2007 lacks the capability to move by drag and drop, individual data points on a graph. Does anyone know if...

Hi! I need to compare and merge two worksheets but the 'Compare and Merge Worksheets...' option is greyed out. I made sure both worksheets are in the same...

I hope I am saying this correctly. I am trying to create a formula that would give me the following result in cell A1. If the value in cell A2 is equal to...

Hi I have created an excel file that has some cells that are locked and others that are unlocked so that people can add data and submit the data to me. I...

I am attempting to conditional format an entore row based on one columns results. What is the best way to do this? Thanks.

Currently I have a data sheet that looks like this: _____A_____B_____ 1 A Data 1 2 B Data 2 3 A Data 3 4 C Data...

I'm not really sure when the "Add-in" button appeared on my ribbon, but it was either after an update or installation of a program. Everytime I would open...

Hello, The following formula works great, except when the cell it's referencing is blank, then I receive #VALUE. What do I need to do in order to fix this...

HELP!!! I imported data and the resulting excel sheet has a gray area along the left side with little buttons at the top "1" "2" "3" and vertical lines...

I try to save a file with text and I get the following message: file.xtx may contain features that are not campatible with Text (Tab delimited). Do you want...