Hi,
I'm doing a formula that takes info from a worksheet in one workbook and
copies it to another worksheet in another workbook.
My formula looks like this: =('[9-07 Chart Audit Compliance

I have this sample data:
Project #  City    State    Address         Department    Staff
1      Phoenix    AZ    123 Fake Street    HR    3
1      Phoenix    AZ    123 Fake Street    Legal    2

If need help on a formula that will return "not okay"for the following
condition:
If col B > cell J679 AND col A is BETWEEN 1.65 and 1.99 then "not okay",
otherwise ""

I have downloaded data that has 7.5 in cell G2. I used G2*100 to get 0750 in
cell I2, formatted as 0000.
To convert the .5 hour (50) to 30 as minutes, I used in J2 (right, I2,2) to
pull out the 50, and then in K2 =IF(J2="50","30",J2). This does give me the

I would like to use the If function in order to fill out certain cells
containing text. The idea is this:
Depending on what name was entered in column B a different result for
C/D would be entered  For column C & D I would like to have an "If"

Is there a way to program a cell to display a referenced cell UNLESS you
choose to override it with a manually inputed value? Thanks in advance

I'm currently creating a Physical Fitness Test roster for my work. I'm making
it to where as you fill in the information, it automatically puts the point
values into the corresponding cell.
I have three categories: Pullups, Crunches, 3-Mile Run. I have the Pullups

Trying to Match information on two different worksheets and populate a
cell if a match is found
Worksheet A,
Column A=Server names

Help - I just upgraded to Office 2007. For some reason, when I filter data in
one of my worksheets and try to copy the filtered data into a new
spreadsheet, all teh rows in between my filtered data are copied to my new
spreadsheet as well and not just my filtered data. I never ...

Entered several lines of text in cell using "wrap text".  No problem.  After
about 20 lines newly entered text would not wrap.  Used AutoFit and there was
no change.  Manually expanded the cell and no change.   Does anyone know why
text will wrap for 15 + lines then all ...

Sheet snippet:
                   COL A         COL B           COL C                COL D
COL E                COL F
                   DateTime    StrtTime       EndTotal            Hours for

How to specify cell length with text and leading spaces?
I want a cell to have only 35 text characters; however, I want the text I
enter to be counted with leading blank spaces. Similar to the leading 0
function that can be configured in the Format Cell, Number, Custom to mandate

In this if statement:  IF(A1=100,1,"") I would like the 3rd parameter to not
return "", not return 0 but return NOTHING.  Is there a way to return empty,
blank, etc?

Doing an amortization table beginning with 10/2007 want to quickly advance
the dates quarterly for the next 10 years.
Thanks

I have a column that has leading zeros.  I want to get rid of all leading
zeros.  Some have 3, some have 2...etc....SOme of the cells have letters in
them also.  SO what can I do?  Thanks