I need a formula that will allow me to cycle thru 10 days and back again.
There are 10 levels, starting with level 1.
every day that passes, the level goes up by 1, not to go over 10. So every
10 days, the cycle starts over agan.

I find data has moved about 10 cells below where it should be.  How do I
prevent this?

I want to count how many let's say wednesdays are within a calendar month and
for each month of the year

I am trying to create a formula in a pivot table in Excel 2007 that will
give me a percent of orders that have completed service orders.  Here is an
example of my pivot table data:
Filter: on date

I have an array of cells that all rely on a "Y" or "N" value in another
cell, and an IF statement to either make the data appear or not appear.
It works fine, except that when the data appears and fill, the borders
pop up fine.  Some of them, however refuse to disappear the same way ...

I have Excel 2007 and am attempting to use the data validation tool.  I have
created several lists in a separate worksheet and named them (In the name
box).  My drop down and options have shown correctly.  However, I now need to
make a few changes to the lists.  I  added a few ...

I want to add up the values of various discontiguous cells in a worksheet
e.g. A2+A7+C4+D7+G3. What is the quickest way to do this? The autosum
function doesn't seem to work for this. Excel 2003. Thanks.

Does anyone know of an easy way to accomplish this?
In the example below, I do not wish to add the values in columns G18 and J18.
=SUMIF(F18:L18,"<>#N/A",F18:L18)
Thanks in advance for any replies.

I have this formula
     =SUM(IF(ISERROR(A1:A100),0,A1:A100))
entered as an array formula, to sum a column even if some of the cells
contains error values.

hi deares
i want a formula that if worksheet protected it return "text1" and if
unprotected it return "text2" in a sell.is possible?
kind regards

Column A is not formatted as a date but does contain the year and
month as 2010 03.  How can I use Conditional Formatting to highlight
that row when it is the current month and current year?
thanks to all...

I want to automate Invoice numbers to my spreadsheets.  I have saved the
file as Read Only.  When I open my Excell 2003 I enter client details.  I
want an invoice number allocated to this client upon being saved.  When I
open this client file the next day to update details I ...

I have a billable rate of $70 with a mark up percentage of 17.65%. How do I
calculate the base rate?

I accidentally added an Advanced filter for part of a range.  I cannot clear
it or remove it using either:
a) the advanced filter dialog
b) the clear toolbar icon

hi deares
i want formula that if worksheet protected it return "text1" and if
unprotected it return "text2".
regard