How do I modify a Microsoft Excel template that I downloaded?

I am trying to create a formula which will leave a cell empty if it's
dividing by zero, or give me a result if there are numbers in the
referenced cells.  It seems simple enough, but I can't get it to work.
My formula looks like this:

I am using some basic of formulas, SUM and MAX, within a large file
have started to give 0 as an answer even when this is not the true
result. The same formulas were working previously but have now stopped.
I'm not sure if i have change some display setting, but I don't seem to

I have a series of monthly return and need to create a formula that can
compute it's cumulative return in the following manner:
(1+return1)*(1+return2)*(1+return3))*(1+return4)*(1+return5)
Subsequently, I would need to compute the "average" return by creating

Order Date    Ship Date    First Name    Last Name    Cycle
20051101    20051104    ALITA    FAUSETT    0
20051119    20051123    ALITA    FAUSETT    1
20051101    20051104    BEVERLY    HUSTON    0

Hello from Steved
6.05 a, 9.00 a , 1.00 p, 6.20 p adds to 8.15 Hours
now I will break the above into minutes as set out below
365, 540, 780, 1100 same as above but in minutes.

I have a set of data (a score or time from a school olympic day) and I
would like to be able to automatically rank the top 5 participants on
another worksheet.  Any thoughts on how to do that?
Thanks,

In this function, i would like the cell to look at the current year and
month.  if this is the current month and year, eg may2006, if true, add up a
list of names, if false eg mar 2006, keep the total that was counted when
true.

I have a series of formulae across several columns like this
in say T10
=SUMIF(mqs_col,$N14,'Main Working Paper'!Z$15:Z$2033)
where the last reference (in this case Z15:Z2033) varies in each

I have created a template for a proposal form and I would like a unique,
sequential form number to be added to each proposal that is created.  Do you
know of any simple way of accomplishing this, maybe an excel function, macro,
etc.?  Thank you.

I am trying to format a cell (let's say A:1), as either green, amber,
or red.  It should be based on the values in other cells (B:1, C:1, and
D:1).  
I want A:1 to be green if B:1>80, and C:1=True, and D:1>5.  

In writing a formula, how will you skip the cell with a missing value, i.e.,
#VALUE?
Example below.
          A                     B                         C                

My vlookup doesnt' work if I am looking up data that are in the results of a
pivot table.  If I hand type the pivot table results to a new sheet it will
work but if I tried to re-format the pivot table results or copy the results
as values and it won't work.  It will only work if ...

How can I  search the minimum and maximum values of the rows that follow a
specific condition?
e.g.
A mission means having to travel to a set of destinations.

I have written the macro (my first!) as below
Function FindOldNominal(NomCode)
FindOldNominal = WorksheetFunction.VLookup(NomCode, range("IMPORTRANGE"), 5,
false)