When creating a formula, is there a way to differentiate between a blank
cell and a cell that's equal to 0?
Here's my formula:
=IF('2005 Sales'!O12>0,'2005 Sales'!O12,"")

Hiya
Does anyone know a formula or macro to show the username in a cell.
By username I mean either the name under Tools>Options>General or a
network logon name.

I am trying to figure out how to add the number of items placed in a
system. Each system has multiple items in it with different yearly
quantities.
For an example, in sheet1 I have a table with 3 columns A- is the item#

Hello, need a little help please.
I would like to compile a list of numbers I have typed into a cell o
one page and list it on another page without writing over the numbe
but putting it in a different cell.  

I'm needing some help with performing a multiple column condition formatting.
I have tried many "forumula is" in the conditional formatting with no
success.  I'm missing something.
What I would like to have happen is, if the 2 conditions are true then I

I have a 4 page table which I want to print. The 1st page prints fine, but
the 2nd, third and 4th pages print the first 10 rows of the 1st page and the
remaining rows of the page being printed (2, 3 or 4). Print Preview shows
the same thing. The Page Break View shows everything ...

New to the group and was looking for some formatting help.  I have a
rather extensive financial model that covers approximately 400-500 rows
on the inputs sheet.  I'd like to set up a separate input that will
consolidate unused rows / columns.  For example, the model enables a

Im trying to create a spreadsheet file where I can input data into a
column and have it insert a certain factor.  For example I want to be
able to input data so that if i type 70 in one column it enters .985 in
the next column and if i enter 71 then 979 is entered that column and so

Ok, here is a fun exercise.  I somehow got in charge of all the
technical stuff for my monthly office home poker night.  Meaning I am
developing a payout table
It was pretty easy to come up with a schedule that made sense, but I now

w-w-w-.-b-a-g-1-8-8-1-.-c-o-m-
http://www.bag1881.com

I am trying to understand why wildcard characters don't always work.
Consider the following table:  
A
1  Yes

OK LET ME TRY TO EXPLIAN WHAT I NEED.  I made a worksheet, with all the info
i need on it, now I only want to print it out just once. when I need to
print inserted
text I dont want to print the whole thing out again, just what I inserted

The following worksheet (as an excerpt of a bigger one) is to be analysed:
x    x    2
x        1
    x    2

please help, I want to write a list of items in one cell which when the item
is selected will place a value linked to that item in another cell which in
turn will do the same to another cell. Any ideas?
Thanx in advance

I am making a list for my dvd's with excel and the way that i did thi
is that I used a column for each letter,  column a for movies startin
with a...etc. and what I want to know is the formula that adds up th
tolal number of cells to get a total of how many dvd's I have pe