I was referencing another cell with an Excel formula and wanted the formula
to return a blank cell if the referenced cell was blank.  I searched for
"blank" and "if" in Excel help and didn't find the function to do this. My
formula ended up being:

I am trying to create a schedule that calculates hours worked in a day.  I
have several restrictions in space, so would like to have one cell that shows
start and end time, and a second cell that shows hours worked.
For instance

I'm a beginner, so bear with me...
I'm trying to create an IF statement that will say whether or not a
given date since January,1,1900 is a friday. It should answer "yes" or
"no".  I've read a lot of the postings and I'm more confused then

Hello from Steved
=IF(ISNA(VLOOKUP(D6,$S$2:$W$2000,5,FALSE)),"",VLOOKUP(D6,$S$2:$W$2000,5,FALSE))
Ok the above is fine it picks up the 5th column Col W
Question is it possile to lookup the column to the left ie -1

I want to use the following function: SUMIF(a2:a31,<=a1,b2:b31), but excel
requires the criteria to be text as follows:
SUMIF(sheet2!a1:z1,"<=a1",a2:z2).  The result is that it does not see a1 as a
cell reference, but it sees a1 as "a1".  In my case, a2 to a+ are the dates

I have a column in excel (2002) of numbers with dashes in them (for example:
04-115-5-0606), and I need to take the dashes out.  I'm using the
text-to-columns function, then concatenating it back into one column without
the dashes.  

I am tracking dates of service and I need to be able to see if dates fall
within a certain time frame.
                 column F             Column H
 row 1        (date 1)                (date 2)

How do I set a "tomorrow's date" in excel (similliar to TODAY( ) but only for
tomorrow's date)>

I want to calculate results of an incentive that has 3 components all of
which are 'x' times $5 to calculate their total bonus.  
Any combo of the 3 can reach a cap of $400.  My question is when one of the
3 cells reaches the cap of $400, how do I get the other 2 to default to 0

I have 12 columns of data.  I need to create if commands that if the data on
column 1 is between a certain range to transfer the amount, if not, try the
next column, for six columns.
sample data

i have to like invert several colums... i dont know how to do that
without retyping the whole thing, is there another way? :confused:

We have a shared drive where we can share excel worksheets.  At one time
when one of us had the worksheet opened and the other person opens the
file we would get a message that this file is in use.  Is there a
setting in Excel that you can select for this?

When working in excel 2003 I try to copy and paste in the same workbook in
split screens, from one screen to the other. The hourglass comes up for about
5 or 10 seconds and it erases the clipboard. My laptop has excel 2000 and I
don't have this problem. What's up and how do I fix ...

There are two spreadsheets in this project. On one spreadsheet I have over
8000+ rows with several columns: one column contains a product number,
another contains colors available for the product, and several other columns
describing the product. On the second spreadsheet I have ...

perhaps somebody knows how to do this:
in column A i have different values, for example:
   A    B
1  aa