I hit another road block with my formula.
=IF(I19="yes",(((D15/52)*0.6)),0)
The max value can only be $1,000.  How do I tell it if D15/52*60% is more
then $1,000 only enter $1,000.  If the value is less then $1,000 then enter

does anybody reccomend any add-in and/or best practice to grapple with long
command statements ?
All the best,
Alex

we have to use arrow keys to manuever spreadsheet.  very large spreadsheet,
last year got error message of "too many cell formats."  questions:
1. would it make a difference to move up to v. 2003 (on 2000 now)
2. what is causing problems

How can I add the same cell of diverse contiguous spread sheets; example:
(Pla1 H1 + Pla2 H1 + ...).  the formula is: [=(Pla1!H1;Plan2!H1; ...)];
however, if I will add many spread sheets (50), the formula will be extremely
great. How can I simplify the formula?

I have about 60 rows of entries in a microsoft excell sheet, each entry
consists of about 6 cells with more information, such as address, funding,
description etc. I want to alphabetize the entries. But I would like to do
this in a way t hat keeps all the information in each row ...

Is there an easy way to test the contents of a cell for a particular
character string?  I have a number of records that I've dumped out of an
AS400 application and need to search one column for the word "Shell".  The
word is only part of the cell contents and is a varying number ...

Is there a way for me to see what cells within a workbook, or worksheet, are
referencing a specific cell?
I had all data on one worksheet, then I cut 1/2 of it and pasted it into
another worksheet and consequently one cell in the original worksheet is now

It would be great if Excel could sort by month name, such as Jan, Feb, Mar,
etc.  
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the

I've got a master list with 100's of items.  I have four columns of
information for each item. (Description, supplier, item number, cost).  I
want to generate a list on a seperate page by supplier.  For example, every
item that is made by ABC company is put on list A (seperate ...

I am creating several documents from one main source document in excel
2003.  
The match and offset fomula created are working fine, but will only
show the values when the source document is open.  When you select

I'm trying to write a funcction that will calculate the amount of
incremental sales I would need to cover my costs if I were start paying a
sales commission.
Example:

I have devised a Cash flow template which I now need to be able to sort date
in the same row for so it can automatically calc brough t fwd invoices paid
and invoices raised in the month which are paid.
Eg.

I have a listing of 24 hourly values for each day of the year in Column
B.  In column A I have the date/time for the recording hour.  I need to
find the 5 highest daily max values and also the values for 5 hours
before and after each peak.   Is there a formula or formulae that I can

I am unable to print the gridlines when using excel spreadsheets .This is a
recent problem as they were printing ok. The box in page setup is ticked. Is
there another command that needs to be checked?

I want to use the daverage function to compute the average on several columns
for example according to a certain criteria I may want to copmute the average
on columns C, E, and G.  Other than taking the average of "nested" daverages,
is there a slicker way to do it?