|
|
#N/A error messages by
Loren Newton
I am trying to sum a colume that has some cells with '#N/A'. The cell with
the total, displays a '#N/A' now. How can I have that cell display the total
of...
|
|
2 |
431 |
|
|
#N/A error by
Bill R[_5_]
I have SpreadsheetA which (in a column) takes data from SpreadsheetB (in a
row). (A simple = ...). So far so good and both spreadsheets are saved and...
|
|
5 |
1,141 |
|
|
#DIV/0! Error by
Joohn Calder
Hi
I get an error (#DIV/0!) when I divide one cell by the other and there are
no entries in the cells.
How can i get the folrmula to surpress the error (show...
|
|
1 |
470 |
|
|
#DIV/0! by
Jim S[_2_]
What does #DIV/0! mean when it shows up in a cell with a formula?
--
Jim S
( 1 2)
|
|
14 |
665 |
|
|
#Div/0 by
H
Hi - is there a way to avoid getting this result #DIV/0? Can I divide and get
a line or something instead when there is nothing to divide by?
=B5/A5?
Thank...
( 1 2)
|
July 31st, 2009 06:13 PM
by H
|
10 |
709 |
|
|
|
|
5 |
457 |
|
|
###### when trying to enter a $ fugure by
Justina
I am getting ##### but closer together in my worksheet when trying to enter a
sales figure, i have chkd the format cells option with no joy, the rest of
the...
|
|
4 |
446 |
|
|
#### by
Teri
What does it mean when these ##### come up? how do I fix it?
Also, how do I add ZERO's? When I add a ZERO, it is not included.
|
|
4 |
449 |
|
|
#### by
Cgirlcj
Ok, so, I am in an MS office course at school, and I am trying to get a grip
on excel, but I cant seem to get auto sum down well. I know the reason I am...
|
|
1 |
448 |
|
|
### signs! by
Tara
Hi,
Sometimes I can fit a lot of text in a small font into a cell. Other
times when I try to fit the same amount of text into another cell, all I end
up with...
|
|
5 |
513 |
|
|
### 100% FREE EASY MONEY MAKING IDEAS ### by
jahanvi
Wouldn't it be great to work the hours you want, when you want?
How would you feel about being your own boss?
Imagine having the freedom to work from home or...
|
November 15th, 2007 04:02 PM
by jahanvi
|
0 |
494 |
|
|
# sign by
Duplatt
I have several cells that refer to other cells ie: = Sheet1!$b$21
they worked fine until a couple days ago. Now they all have # in them
instead of the number...
|
|
6 |
591 |
|
|
"tip" sheet by
Pete
Does anyone know if Microsoft offers (for purchase) a laminated "Tip" sheet showing commonly used functions, formatting, etc? I know they offer one for...
|
|
3 |
767 |
|
|
"See" Custom Property by
zSplash
I have set a custom property "test" with code, but cannnot "see" it when I
go to File | Properties | Custom. When I "get" the value with code, it's
clearly...
|
|
0 |
486 |
|
|
"Printed by:" in Footer by
Ruan
Hello,
Is there a way to display the User who printed the document in the Footer?
Thanks
Ruan
|
June 1st, 2004 11:25 PM
by CLR
|
5 |
589 |
|
|
"merged cells must be identical size." by
jayceejay
HELP! I have a multiple sheet workbook each with an identical table that
needs to be sorted on a specific column at the end of the month. When I
attempt the...
|
|
1 |
669 |
|
|
|
|
2 |
456 |