When I have no entry in a cell within an IF statement it returns as
"FALSE". I want it to be blank and have no value.
If I use if(ai="","") I still get FALSE unless the entry is done via
the spacebar and then I get a blank cell. How do I get a blank cell

How do I sum column A if the value C is common?
A          B        C
15.2     2      aa1
23.0    1.5    aa1

I have used a visual basic routine to save the date and time when I save an
Excel  file.
Private Sub Workbook_BeforeSave(By Val SaveAsUI As Boolean, Cancel As
Boolean)

When I open Excel I get this error message: "Compile Error in Hidden
Mode AutoExecNew" and get this one when I close Excel: " Compile Error
in Hidden Mode. DistMon". How do I resolve this? Thanks, David

I need help with Xcell 2003 program as I have difficult time following the
help instructions. I have a list of names arranged by last name, first name,
E-mail affiliation. I want to add a new name. I write it in the empty space
where the little star is at the bottom of the list, ...

How do I email a spreadsheet.

I am trying to do my homework again.  I have done everything I can to get
this to work and I keep getting error messages.
I am trying to get the letter grade on 3 worksheets.  I have a forth
worksheet that has the criteria for the letter grades.     I have a list of

I want to break a link in a given workbook. Edit > Links > etc. But the
"Break link" button is missing. What's happening here?
Robert

I am trying to understand various points of the programme listed below and
given in a book as an example (I have deleted some of the lines of code not
necessary to this question, and commented some of the lines – the original
had no commenting):-

I run WinXP with Excel 2000.
I have a pivot table that uses data that is formatted in non-proportional
fonts (ie: Courier New). The pivot table is also formatted to
non-proportional fonts (Courier New)

I am new to data validation in Excel and would like to seek your advice on
the following items
1) For a particular column, I would like end users to enter 6 numeric digit.
I have tried to choose Decimal with min 6 & max 6 but doesn't work. Then I

I'm trying to build a check for customers that will highlight verbiage
when something isn't allowed... This would be my optimal solution
="Currently it adds up to "&TEXT(D14,"0.0")&" which is
"&IF(MOD(D14,1)=0,"",text("NOT ","[Red]"))&"a whole number."

The CSV column that is in issue is filled with dates and nulls. It is an
exported list from a software program we use.
When you open the CSV file with Excel and it automatically converts, it sets
the date fields type as General. Even after you change the field to a date

I almost completed my application, and I needto import some photos in the
document. It is about 20 photos, and  I mamaged routine for selecting and
placing phots in the documnet. Problem is now that excel file is too big,
when photos are of 2-3 MB each, excel file becom 20 MB an ...

Hello all...
I have a fairly straight forward formula:
=sum((F29-E29)*(C29*D29))
When the resulting answer is negative I'm very happy... but when the