=IF(B3=0,(C3),(B3) and IF(B3=C3, (" "),(B3&" "&C3))). I wouldn't know what am
doing wrong. Please help. Thanks.
if column b3=0, then pick column c3 else pick b3, but if column b3 and c3
are same pick nothing else combine b3 and c3.

I've got a worksheet, c 200 rows, with data in Cols A to L (range name
"Data") where Column L (range name "Result") has a series of variable
numeric values.
I want to create a new worksheet that reports just those rows that satisfy a

Can you use "AND", "IF" and "SUM" Functions together?
I want a formula that will do the following;
IF C:C = "Name" AND I:I = "5" then SUM K:K

I am trying to enter horse pedigrees to a sale catalog. I am wanting to be
able to type in M_1 and it will produce the 3 generation pedigree. I have the
pedigrees all entered on one worksheet but the catalog is on a different
worksheet. What can I do?

I’m trying to construct a smart worksheet so when I enter a number or any
value it will automatically give me a specific result if it meets the
requirements from a first worksheet.
Basically I want to use a formula that when the last two digits of a number

...  according to the value of a cell hosted in another worksheet...
Hi,
My cell A4 of the worksheet "Dashboard" is:
="Evolution of " & TEXT('Global Data'!C39;"#%") & " from previous month"

I have a sheet whit the following data:
DATE        Subject
April 5, 2008    citi
April 5, 2008    citi

I have a list, say 50 cells, named "Charlie". I want to add to extend that
named list to by 60 cells. How do I do this in Excell 2003?

I would like to have a list the if the criteria is TRUE for a list item then
the cell with the list item in is formatted according to the rule.
Is this possible?
cheers

I am trying to write a function so that if A or N appear in a row, the
number of occurances will be counted and logged. If the result = 0
then that row will be deleted. If have it working with a COUNTIF for
one variable, and I understand that nesting more than one does not

I asked a previous question but did not get the answer I was seeking so I am
restating the situation. Following is the situation and I am seeking advice
on the best approach to accomplish what I need.
I am using Excel 2003. I have a spreadsheet with about 150 columns and 1000

Hi,
I need a solution to the following problem.
I have a template for each member of staff [e.g John Doe Time Tracking.xls]
(for about 50 people) to track time spent on particular activities (projects)

I am working in a spreadsheet and I need for my column heading in column A to
apper on each page?  I do not know how the text should be entered in the
field.

having a column in which data is entered like (1 line here denoted 1 cell)
1,14,17
2
3,8

I have, for me, a very complicated scenario and I am hoping someone can help.
I need to populate a table with the total number of work hours a person is
responsible for on a given day.  For example, I need to return the total
number of work hours for Jones on 6/3/2008.  My data ...