I have 10 possible ranges to create a cell value.  I cannot use "IF" beyond 7
and I keep seeing suggestions to use "Lookup", but it's not working.  I need
some examples if they're out there.  Here's what I'm trying to do:
If the cell value in "X" is: <30, then value is 1

The StdDev gave number much smaller than the squre root of sum of square of
deviation from the mean. How is it calculated?

How can I format diffrent font size and color for only text "Sample"
while using formula =concatenate(c2,"Sample",c3).

I really hope there is an easy way to fill cells down without retyping this
formula:
=IF(J117="","",IF(P1014>=100000,J117*0.019+0.3,IF(P1014>=10000,J117*0.022+0.3,
IF(P1014>=3000,J117*0.025+0.3,IF(P1014>=0.01,J117*0.029+0.3,)))))

I am using Excel 2003 SP2 for managing my address list.
When I select col 1 and and press sorting button A-Z , it ask for
expanding selectoin, On hitting YES,
it does sorting but in two groups.

I want to generate random times (every couple of hours) for dates. For
example, we have a security exercise that is randomly generated for given
dates, or every day. Reply to: dhartman@dossifs.com

I'm trying to insert the formula for the correct results below.  Here's what
I have:
                                                  Int Rate          Int. Amt
Total Principal         No of days       (L+1.5%)

I have a list of construction labor rates that are contained in (5) seperate
tables in which I would like to use the VLookup function. I have yet to
figure out how I can use the function with a table that is seprated into (5)
sections. It may be that there is no way to use the ...

How would I incorporate 2 criterion into the SUMIF function?  For example, in
the following example I have the formula look to the A2:A2000 range for the
value referrenced in C2 and sum only those numbers in range B2:B2000 that
meet this criteria.  That's the easy part.  How ...

How do I format a cell to automatically add brackets to the number entry to
show it is being subtracted by a formula that is elsewhere. Or, how do I
make the entry automatically negative (will adjust formula to keep from
subtracting a negative.)

I have this problem; I have a worksheet that is protected, the user kan
change values in 4 spesific cells. My macro unprotects the sheet, calcualte
and protects the sheet again. Now I would like to protect the sheet so that
it will not be changed by a mistake, so that the user ...

i am wring aon a scheduling spreadsheet  i am tryo to find a way so that i
can enter a character in cells in one part in the preadsheet to stand for
shifts and so that i can have tha chaacter stand for a number so that i can
use it to come up with a total .( the bottom is divided ...

I have the following problem:-
A spreadsheet with two different worksheets.  I have a list of numbers
in column A of one worksheet [2000 to 4153], with a list of names in
column B [A Adams to Z Zeta].  I have that same list of numbers

How can I subtract a range of numbers from another number?

I have a years worth of dates in Col B and need to do countif and countblank
in Col D but I need to seperate by quarters,  I was thinking of doing it w/
an if statement but didn't work,  I could sort by date and copy to individual
worksheets but I have 3 tables w/ 45K+ records ...