The following formula returns a numeric(percent) value:
=MIN(IF((LEFT('PDAs Report'!G3:G1000,3)="BJ ")*('PDAs Report'!
H3:H1000>=L9),'PDAs Report'!J3:J1000))
In order for the numeric values to even be evaluated, the following 2

Is there a way I can rename files:
AFT.11.DAT
AFT.12.DAT
AFT.21.DAT

I created a list of office supplies in Excel that my office regularly use.
What I would like is for the employee to open the worksheet, enter the
quantity of the supply requested and their inititals. The information they
enter is copied to a hidden worksheet that I will use to ...

I want to look up the closest completed Week Ending Date & return the
value of remaining Vacation Time from column I, for the appropriate
week ending date.
'WEEKDAY' = Week Ending Dates for 2007

I know that "ticks" work well with formulas such as:
=IF(OR(A1="",B1=""),"",IF(A1=B1,"a","r"))
Can the formula to adjust to accomodate text as well? I wasn't sure! I tried
it, but it only seemed to register numerical values.

I've researched this for some time without success (or because I'm not as
well versed in Excel, may have overlooked it...)
I'm trying to set up a trouble ticket spread sheet where there's minimal
technical input required by the user:

I am building a report template that pulls like data from different vendor
workbooks. I want to be able to create "Dynamic Formulas" that can "Read"
what vendor I am working with and change based on that information.
For example;

Hey,
Please help. I'm trying to write a formula for the following:
If A <= 0.35, then "Level I" or if A > 0.35 and <= 0.70, then "Level II" or
if A > 0.70, then "Level III".  

I have two sheets in same workbook, first one is a list of parts with lots of
other data (product code, qty, etc) In the second sheet I have a list of
parts with other data (#times quoted, qty, etc) I need to get the data from
sheet two to appear on sheet one where the part numer ...

Hi! This is my first time posting so I'm sorry in advance if I break
any Usenet etiquette..
I have 2 unrelated questions, and I've spent many hours searching for
the answer on this group and on the internet but I couldn't find it,

I see a couple of similar questions already posted but they don't 100% help.  
I have a list of currency data - similar to stock data.  It shows highs and
lows during a specified period of time.  It looks like this:
        High    Low

I need to remove only the first 10 characters of 40 character cells in a
given column.
What is the formula to produce this result? All cells are currently 40
characters in length.

I have a question?
Is there a formula that I can use which references a different "tab" on my
spreadsheet.  
For example if on sheet 1 (which of named New Rules) I have dates in which

I am creating a spreadsheet for a project and I am trying to assign a
numerical value to certain types of equipment used.  For example, labor=$25
Loader=$150 ect.  I have multiple equipment that is used throughout the
spreadsheet and I would like for them to duplicate the value ...

In Excel i have a spreadsheet with 4000 rows of data and would like to
randomly select a list of 780 rows showing only one cell of the data?