How to perform calculations using time as arguments?
E.g. "F1-F2" works fine where both cells contain values with (h:mm) format,
but "F1-8:00" returns an error. Also, when using =IF(),  when [value_if_true]
is "f1-8:00" I get a formula error.

Help.
I am importing .xls information into a custom / proprietary contact manager
system.
Problem is the Excel address information comes in 2 columns 1) the house

I am trying to create a formula that looks at two variables on Sheet 1 and
returns a value from one of two columns on Sheet 3.  
Essentially, what I'd like it to do is:
If B27>7 and B28<25, then return the value from sheet 3, C4 in C28 (first

this is trivial example
     1-May 1
     1-May 2
     1-May 3

I have set up a purchase order workbook.  What I want to do is have the
shipping and handling cell calculate 3% of the subtotal or $10.00 (there is a
10 dollar minimum).  I can do either or but don't know how to do both.  If
it's not too complicated or time consuming, can it be ...

Hi, I am trying to write a formula within the conditional formatting
dialog box. I have a column with dates and I wont the cell to become
red whenever the date in the cell is more then 3 years older then
todays date. Does anyone have an idea of how to write this formula?

I have a column of sales figures and I need to determine if they qualify for
a bonus.  Sales figures over 300 qualify for a bonus of 10%.  Is it possible
to do this?  Is there a function?
Any help would be appreciated.

I need to calculate on a spreadsheet the number of days between a specific
date and the date the spread sheet is opened.
I need to know the number of days a merchandise has been stored.

Is there a way to limit the rows of text in a textbox object (placed in a
worksheet, not a form).
The users want to be able to stop a user from entering more than a certain
amount of text.  They don't want any error message to appear (as the

I have a small spreadsheet, where A1 to E1 are headings, with columns
like this:
        A          B         C         D              E
1    DATE    Lime/g  Alum/g  Chlorine/g  Carbon/g

I am trying to solve a log series equation in an Excel 2003 spreadsheet.  I
want to have excel adjust a single variable in the equation to find a product
equal to another value.  The solver function ALMOST works, but requires that
the "equal to" value be minimum, maximum, or a ...

I Excel 2003 I have 3 drop-down lists.
In list one is 1,2,3.
In list 2 it is A,B,C.
In list three it is $,€,*.

I have nearly 20 sheets of data all different values of columns and rows and
would like to create in the first empty sheet a search menu. I would like
this first sheet to be capable of displaying data from another sheet by
selecting the sheet name, rows, and columns from drop ...

Hello experts,
A previous employee created a spreadsheet whereas in Column A are employee
names as follows:
Doe,John

I have a column of data, each cell separated by a blank cell.  The blank
cells need to be filled in with the data immediately above it.  Fill option
to do this?