I plotted the curve y = 1200-4x. Can I find the area under the curve from 0
to 5 using an excel function?

I am building a financial worksheet which will involve daily entries for
sums of money progressively going down the page.  Can anyone tell me how to
determine the total number of entries there are so an average payment value
can be calculated?

I'm looking for a formula that will allow me to automatically fill in a price
(from a price group containing 5 different price levels) for a listing of 60
to 80 products.
Ex:  There are 60 different pens - each named differently - that I would

I do not get it. Why would MS limit your ability to choose heavy border
lines? Goes anyone know a way around this limit?

Have dates in column S, and quantities shipped in columns M & N.
Looking for sither a SUMIF OR SUMPRODUCT formula which will give us
the year to date shipments in another workbook.
This one doesn't do it. . .Produces #VALUE .

We are using the following formula and it returns N/A
=IF($A79>0,IF(VLOOKUP($A79,'BO
Output'!$A$3:$P$2002,4,FALSE)="","",VLOOKUP($A79,'BO
Output'!$A$3:$P$2002,4,FALSE)),"")

I'm sure its something simple, but I am having trouble protecting specific
cells in a worksheet.  Followed the help instructions, but not having any
luck.
Need to protect a row of headers and the next rows will be used by others,

Using a collegues formula:  =IF(D6=0,0,F6/D6)
I am trying to get the % change between columns D and E.  Problem is D and E
contain Zero at times.  If D has a negative number or Zero, the % change is
not always accurate.

How do I get a cell to inout what is in that cell unless it is blank, if it
is blank then return what is in  another cell, if both are blank then return
nothing.
Example:

I am trying to calculate a sales commission using excel, I can do bits of it
but cant get every break point to calculate.
The main variables are :
       Sales Target :  e.g. 120000

I'm trying to write a complicated equation and I need it to search 2
different cells for the word "Sunday". I'm trying to put both in an IF
equation, but they won't both work properly. Here's my example:
=IF(SEARCH("SUNDAY",D28),"",IF(SEARCH("SUNDAY",D25),Z23+1,""))

I want the font in column H to be red until I enter 'Y' in column D.
What is the formula, and do I use a conditional format to do so?

Hi, I want to retrieve the data in a a cell in Sheet2, based on the value of
a cell in Sheet1.   How do I do this?
For example, in Sheet1, cell A1 has the value "5".  In cell A2, I want it to
retrieve the data in cell B5 of Sheet2 (the 5 coming from the value in cell

Rather than referencing a range for a given Name, I have typed in a formula,
which typically works.  However, I have noted that when using a formula that
includes other named ranges, I get the #VALUE error.  Is there a way around
this, or is it simply a weakness in Excel?

I want to enter a value in a cell and have it automatically add a
predetermined value to it. I'm using excell 2003