What I'm looking to do is basically this:
=IF(C23<>0,"=D20-C23","None")
I want the formula to give me a number if true and say None if false

My workbook is relatively small...approx 8,000kb. I have about 30 charts and
I am trying to copy 4 charts and paste them into the same worksheet to create
4 more charts. When I try to do this I get a message "no more new fonts may
be applied in this workbook". Is there a ...

I have a UPC code I am trying to upload to nextag.  When I convert the UPC
code to Numbers or Text and then save the file as .csv for uploading, the
first digit of the UPC code disappears.  
Ex: 0-18787-76631-6 I have to remove all dashes, apostrophes, etc, as per

Hi, can someone help me with this:
the following formula works:
SUMPRODUCT((YEAR(B17:B53)=2005)*(C17:C53))
if I stick in the year in the formula, e.g. 2005 as in above. But when I

Hopefully, someone can point me in the right direction here. I have entered
the following eqaution into one of my sheets...
=IF(AND(AC3=1,AD3=3),6,0)
Now, even when AC3=1 and AD3=3, I'm still getting 0 as the result when I

I read that you can do (B1-A1)*24 but for the values where A is in PM and B
is in AM this returns a negative hour much larger than what it should be.  
Any recommendations?  Thanks.

My formulas are entered correctly but when i enter new data they don't
recaculate.  Any Ideas what might be wrong?  Excell 2003

i want the cell to write the number to a text
like
9 to nine
is there any function make number to text.

Sorry my previous post did not make sense.  I meant to say
1 disc is Office XP Small business and the other is Office XP .
Thanks again

Col "A"                 Col "B"
8/18/06                Vlookup formula (result is $5)
8/21/06                Vlookup formula (cell not updated yet so result shows
#N/A)

I'm using excel 2002 and have a worksheet with approx. 450 row entrie
and a 10 column list header.
For some reason, when I apply the autofilter function the results see
to be 'sorted' rather than unwanted data being hidden.

i m trying to save an already opened workbook using vb code but the
instr
app.activeworkbook.close dosent work as it says object required kindly
help me save an open excel workbook

Hello Fellow Excel users,
I have alittle problem which i hope somebody can point me in the right
direction
Picture my screen in excel

I faced with a problem in my excel sheet. I made a big table with about 2400
cells. I used hyperlink files in one column. But recently I faced a problem
if I want format a cells, for example: merge two cells, it will send a
massage TOO MANY DIFFERENT CELLS FORMATS" and deny of do ...

Upon opening a file, I am asked to update links.  I click on update links and
receive the warning "This workbook contains one or more links that cannot be
updated.  To change the source of links or attempt to update values again,
click on edit links.  To open as is....click ...