I need help on putting 2 formulas together.  They both wor
independently but when I try to put them together I get an error.
Here are the 2 formulas I need to combine.
=IF($A:$A,">="&S7)-IF($A:$A,">"&R7)

is there in Excel a function that works like "case" command that I remember
from basic. I need to check a cell which can contain several integer values
(1-10), and to have different formula for each value in another cell. So far
I am using a large IF functions which simpliest ...

Is there a way to clear (delete) values from a worksheet
while retaining other information; i.e., can one derive
a "next year" worksheet in one, easy operation?

I created a VLookup function; I even used the function
wizard to make sure my syntax is correct.  The cell where
I created the function shows my keystrokes rather than the
result of the VLookup.  The function wizards show me the

I want to do some conditional sums, averages, etc.  So I
used the conditional sum wizard to help set up the
condition.  It put into the cell,
{=SUM(IF($AC$2:$AC$177=1,$B$2:$B$177,0))}

Excel suddenly refuses to recognize formulas. It just
treats the cell as containing the text of the formula.
Once this morning it got it right; there was no
difference in the way the formula was input- just

I inserted a check box from the Forms tool bar. I am unable to change the size of the actual Check box itself. I can resize the outside of the check box area The peremetre but not the actual check box itself. Help, Please, Anyone.

I'm using an Excel spreadsheet to create a "Dear Dr."
form letter. I need to add a column for the salutation,
but since there are 4000 lines, I don't want to retype
all of the names adding Dr. before the last name. Is

what's a quick easy way to translate a column of names
into a 'neutral' list or nonsensical list of names in
order to submit a BLIND test list to another party?  Don't
want second party to know what the original cell contents

I do my time sheet in military time. Is there a way to subtract military
time?
Let's say:
    E5             F5            G5

Can anyone help?
If the number  in "G" is greater than 10 AND the number in
H is greater than 200
OR if the number in H is greater than 400

Does anyone know how to calculate standard error of the mean in Excel. This is a frequently needed scientific calculation which is availble in Quattro Pro, but I can't find it in Excel.  I suppose I could look up the statistical function and write the formula into each cell, but ...

Is there any way to use lookup formulas to have Excel
find ALL of the values associated with the lookup
parameter and somehow list them out?  Here's an example:
       A           B

Here is what I came up with using 3087 in E5
and =DATE(LEFT(E5)+2000,1,RIGHT(E5,3))
Formula resulted in 3/28/2003

When I use VLOOKUP to find information in a table, if the
value I am searching for is not in the table, it displays
the nearest match.
I do not want this but would like to show no value or some