Using the formula:
=IF(ISNUMBER(C2),0,IF(N2=("SOMETEXT"),0,((K2-J2)*4)))
returns a 0 in the cell if C2 is a number.  Is there a way for me to have it
either delete the value of the cell or make the cell null?  I don't want

Dear experts,
I've a database of clients' information. Column A is clients' names; column
B is account numbers; column C is subscription dates; column D is expiry
dates.

I have the following simple formula
=Sheet1!B15
which of course prints the contents of "Sheet1" cell B15.
However what I want is to get which worksheet to grab from, from a

I want to print out a page but I want 500 copies with 500 different page
numbers?  Is this possible in excel?

i am getting #NA error for the following
array entered formula!
=INDEX(Sheet1!B1:B4,MATCH(A1,LEFT(Sheet1!A1:A4,3),0))
what i am doing wrong?

I have an excel spreadsheet that I need to add checkboxes that can be checked
or un-checked.

I have data that looks like this 123 but I need it to be back filled with
zeros so it looks like this 00123.  I there a function that does that in a
formula?  Thanks.

I'm trying to figure out a way of making the content of a drop down box
differ from what is actually entreed in the cell.
For example, the drop down box contains the word "Information", but when I
select it the word "Misc Inf" is written to the cell.

What I have is a work schedule based on a calendar setup.  I currently use a
macro to automatically save the "schedule" worksheet by copying the worksheet
to a new sheet which renames it using the date from cell A2, i.e. "26 Oct -
15 Nov 2006".  

I have 2 workbooks: 15,000 names, addresses and refernece numbers. On another
I have 100 names addresses and ref numbers. How do I find out if the 100 are
on the workbook with 15,000? I need to use the refence numbers.

Is there an easy way to indentify the weekday from a specfic date rather than
go down the lookup route

I need to do a group and sum for a spreadsheet that looks a bit like this
Company     Market    #ofDiv    Status
I need to get the total # of divisions by market for each status.
Is there a function/ set of functions that will help me do this?

I need some help please.
In a spreadsheet in column A i have numbers from 1 to 100 and in column
    B I have data from some other spreadsheets.
Wat I wont to do is, if the data in column B change for another row then

I need to do the excel equivalent of sql group by count without pivot tables
etc...
Scenario:
1) I have work sheet with list of clients

I want to have a cell in Excel to blink on and off if it meets a certain
criteria.
Any ideas?