I cant get the condA or condB to execute if value of A1 fall within range 1
to 10
if(and(A1 >= 1, A1 <= 10), condA, condB)
How to get the month with a increment value as below

This is probably simple to you guys, but I can't seem to get it to work. I
need a formula that will add together the sum of A1, A2, & A3 cells, then
display (in A4) 20% of the total?
Hope this makes sense.

From http://www.socialsecurity.gov/OACT/COLA/piaformula.html
There is this paragraph;
For an individual who first becomes eligible for old-age insurance
benefits or disability insurance benefits in 2008, or who dies in 2008

I have created a spreadsheet and have restricted a row and footing row
(totals) from being changed by using the "format cells / protection"
feature.  I have left all the data entry rows
unprotected so that the entry people can make changes.  These entry

hi there everyone,
I'm hopeful that someone can help me with my excel problem. Here's my
dilemma: I'm trying to do a results table where results will come from a
worksheet that has different columns, one of which is a date column(let's

I seem to have two XLStart Directories:
C:\Program Files\Microsoft Office\OFFICE11\XLSTART
C:\Documents and Settings\GB\Application Data\Microsoft\Excel\XLSTART
Do I need both? I remember having some problems when I added some xla files

I have a workbook, with multiple sheets, each with it's own name.  Each sheet
has a cell, ie N25, which represents a count function on that sheet.  Now, I
would like to place the sum of N25 of all the sheets on a summary sheet.  Is
it possible to do this with or without using a ...

I have a table that reports results from a lookup table.
The results are in column "L"
I am wanting specifics to be highlighted.
If a cell reports "sam" or "jim" to be blue etc.

I am a newbie in excel and having a problem with
countif function.
Currently in the actual worksheet I was unable to
set a CountIf formula with multiple criteria.

I have a column of dates, and at the bottom, I want to calculate the
number of days between the first and last dates. I' using the formula
  =(DATEDIF(B6,B15,"d"))
The problem is that as I add dates, I have to edit the formula to

I can get the Filename to list in the foot.  But, I need the Directory
information to also print.  How can this be done?

I have a spread sheet created with Excel 2007. One colum has first and last
names in all caps. How can I convert the first letter for each name to be
caps and the rest of the letters to be lowercase? I want to do the whole
colum at once.

Looking for code that would simply, on the fly, depending what was entered in
a cell at anytime, any amount of times, the tab name would be renamed to what
the cell contents are.
I have seen some pretty elaborate ways of renaming tabs. I am new at Excel

This ordinary Excel formula: SUMPRODUCT((x = x )*(y = y)*(z = z),(A:A)) can
be replaced by array formula: {SUM(x = x)*( y = y)*(z = z)*(A:A))}.  
Both formula will produce the same result.  My question is that what is the
extra advantage on "array formula" over the ordinary formula. ...

I want to create a Excel workbook that will help in specific poker
situations.
Short version: I want to be able to calculate how often my opponent will
need to fold for an all-in raise to show a positive expectation.