I need some help with a chart I'm making.
I want an if function to do the following:
IF B1=1,2,3 or 9, then mark B2 with an "x".
Should be simple, but I can never figure out the multiple numbers.

I want to be able to input a date and have the spreadsheet automatically list
the proceeding months with the last day of the month.  In other words, if in
cell A1 I enter 01/31/2008, I want to automatically see 02/28/2008 in A2,
then 03/31/2008 in A3, etc.  If I key in 07/31/2008 ...

I need a addition to make this formula insert numbers as text
=IF($A9=24,"",(IF($A9=20,"190",
(IF($A9=20,"020",IF(ISBLANK(B9),"",""))))))
any ideas

How can I copy the formula so that B2 stays constant and only the row changes?
     A      B     C
1           2
2   10    =A2*B1

How do I pull content from adjacent cells to print as header information in
multiple sheets?

I tried this, but had to change the cell references, but that did not work.
Below is my example. Do you see what I'm doing wrong?
Here is my formula:
=(NETWORKDAYS(A2,B2)-1)*(D2-C2)+IF(NETWORKDAYS(B2,B2),MEDIAN(MOD(B2,1),D2,C2),D2)-MEDIAN(NETWORKDAYS(A2,A2)*MOD(A2,1),D2,C2)

How can I use the Countif Function to count every time the value in one
column/range equals criteria-1 AND the value in a second column/range equals
criteria-2.  In the example below, I want to count every time that column A
equals "Yes" AND column B equals "Red."  In this ...

i am trying to enter a formula that will return a specific number for
a range of numbers.
Example:
i know that if i have between a range of items, that i need to return

This is my formula
'=IF(ISBLANK(VLOOKUP($L11,'Past RDW
'!$L$3:$AI$780,16,FALSE)),"",(VLOOKUP($L11,'Past RDW
'!$L$3:$AI$780,16,FALSE)))

Is there a function which can search for a value in a range and return a
"true" or "false" if it finds it.
eg. =if(A2=B2:B30,12,0)  So if the value in cell A2 is found in the range
B2:B30 then 12, if not then 0.

I am attempting to import into a worksheet that then does some calcs on the
excel sheet
Is there a way to as the data grows to insert the data expanding the space
as needed but not overwriting or deleting as the data is imported

It has taken some time to finally come up with this formula, Chip
Pearson's page gets most of the credit.
=IF($R
$6>TODAY(),SUMPRODUCT((Fiscal="F2008")*(quarter="q2")*(WeekdayAll=4)),SUMPRODUCT((Fiscal="F2008")*(quarter="Q2")*(WeekdayAll=4))-

I am trying to calculate a percent based on the SUMIF function using
non-continuous cells. Row 5 of the worksheet contains the possible points and
row 7 the points the student has received. Have been working at it a while
and having  problems getting it to work. Below is what I ...

My data transferred to the other spreadsheet with no problem, it lost the
format it had in the base spreadsheet such as dates, percentages, etc.  The
problem is at the top of each of my columns it calculates totals and
percentages, and the total is counting all rows transferred  ...

I have the following formula:
=SUMPRODUCT(Data!$T$6:Data!$T$5000="Long
Term")*SUM(Data!$BE$6:Data!$BF$5000)/SUM(Data!$BE$6:Data!$BF$5000)
which produces the wrong answer.