there exists  a function for calculate "endmonth"! Is there another one to
calculate in the same way "endyear"?

Entered into G7 the following
=IF(F7<3,3-F7,0)
F7 is the SUM of C7,D7,E7
If there are no entries in C7,D7 and E7 I want G7 to be blank.

I have been working right along in about 8 worksheets now; opening and
closing them and then this morning I tried to merge some cells and I could
not either by the icon on the toolbar or through format cells. Does anyone
have any ideas? I have no protected worksheets in this ...

Is there an easy way that I can create a chart for a normal distribution
and/or input data so that a chart includes one standard deviation above and
below a specific number? (I have the exact numbers of the mean and what one
standard deviation is... just trying to figure out how ...

I convert spreadsheets from Excel 2003 to a formatted text (space delimited)
.prn file for use in another program. I last used this function in October 07
without any problems. I tried to do this yesterday and the save did not
maintain the columnar spacing, instead it ran ...

I am the owner of a share drive which is posted to a web paige.  I need to ad
a few statements on all of the thousands of documents we have posted.  Is
there something that I can do other than copy and paste to each document to
get these statements on each document?  Preferably ...

I have named some ranges and wish to apply them to all the formula in my
worksheet. I have looked through the help, and it has told me to select a
blank cell, go to the drop down menu Insert, choose Name and then Apply. Then
to choose the name and click Ok.

HH:MM:SS
A storyline has length of scene in col D and running total in col F and
times are entered in seconds.
So:

Good Morning -
What I am looking to do is take the time in/time out and add it to the time
in/time out (lunch in the middle); allow for a rounder of 7 minutes, round
down, 8+ round up.  Then add, PTO, Holiday or Bereavement leave for that day.

I have a report formatted in Crystal Reports and exported to Excel. It lists
costs for various products vertically grouped by source.
EX:
Source #1  Full $3.00

If anyone can help me with this query i'd be very grateful. I'll try and
explain it as simply as possible.
I have the following data. Columns A, B,C and E are manually populated,
columns D, and F are formulaic entry cells.

I'm creating a list of all the sales appointments that have been set for our
sales staff. The list will track which salesperson went on the appointment,
when and where the appointment took place, which product/s (floral
arrangements, interior plants and planters, exterior ...

When i right-click on the worksheet the 'insert rows' 'delete rows' buttons
have disappeared, they were there last week, is there a setting that may have
been deactivated?
Could it be an add-in that has caused this?

I need to creat a dynamic range that that expands as the range of data
grows but ignors  a table of data that is a few lines below the active
table.  using the countA function to check for empty cells works but
if I have the entire colum as the count range it checks for all non

Can anyone explain why I get the correct answer in the Function argument but
0 (Zero) displayed as the result in the Cell. I have an idea it could be
something in the options