I am having some trouble with this.  I have this worksheet on loans.  I have
to calculate a fee for each loan.  ex:  M1*.011=x.  If x<100, it has to be
changed to 100.  If x>225, it has to be changed to 225.  If x is between 100
and 225, it stays that number.  I'm trying to ...

If i have range of data, process formulation, summary check and print_ranges
spread around my 4 sheets....in one stand alone workbook.
Will it be advisable to place all of the above in one sheet, considering
that 2007version has a larger sheet platform....significantly making it a ...

I am trying to change the font from upper and lower case to all upper case
for the entire worksheet, not just a cell. Can this be done?

excel: how to count uppercase letters in a cell

I have a long worksheet (34000+ rows) in which I have grouped data by a stock
number.  In the column following the stock number is the name of the item to
which the stock number refers.  When I subtotal the worksheet and go to level
two (subtotals only), the name disappears.  ...

A little background on the problem I'm trying to solve:
I'm trying to make excel figure out the idea layout of my shop (using x and
y coordinates of each machine) I have part sequences for individual parts of
what machines they travel to, and a total distance traveled. I'm trying ...

I did a search in the archives for a way to strip all occurences of text
from a cell of numbers, eg,
A3F4DR5V1, would end up being 3451.
I found a post from Bob Phillips ( thanks Bob),with the following formula:

When I use SUMPRODUCT formula, especially to look up data from
different workbooks and return to a different workbook, I tend to
have
problem later on when I work on it or save it to a different file.

In Excel 2003 I can hide worksheets then protect them so they are not visible
to others. How can I do this in Excel 2007 ? I've tried hiding columns and
that fine but that still leaves the sheet tab visible.

Let me try to give a simple example of what I want:
I have two worksheets: "WorkSheet1" and "WorkSheet2". WorkSheet1 contains a
column with as column header "IDNr.".
WorkSheet2 contains 2 columns: "IDNr." and "Amount". The IDNr refers to the

I've been working on the formula below but I can't get it to work:
=IF(J10="Yes","(NETWORKDAYS(B10)+5)","N/A")
Cell J10 is in my "Response Required?" column.
Cell B10 is in my "Date Received" column.

Date      01-04-200702-04-200703-04-200704-04-200705-04-200706-04-2007       
GBP    242,32    242,32    243,34    244,07    244,17    243,45   
USD    123,84    123,84    123,34    123,55    123,60    123,37   
EUR    164,87    164,87    164,67    165,01    165,02    164,83   

Simple question:
I want to make a cell on one sheet show an identical value to a similarly
positioned cell on another sheet.  The values in the cells on both sheets are
used for mathematical calculations.

   I am trying to read the values from a excel row. There are 89
columns for each row and same number of data in each rows.
Kindly help
regards

I am trying to learn how to resize the form box that appears when you select
Data, Select Form.  This create an automate form that uses the current
worksheet headers, showing only 1 row at a time for you to fill in.