So i'm attempting this one more time because i haven't been able to ge
it to work for me yet.
Here's the situation:
I want to find the value in sheet1b2 in sheet2 col b and return th

Although I have submerged zero values, and hidden formulas, the cell still
displays "false" when the if statement has not been met.  How can I have the
word "false" submerged.

I am wanting a formula to calculate mortgage insurance.  
If the equity is greater than or equal to 20% the answer should be 0.  If
the equity is less than 20% but greater than 15% the answer should be a
formula that looks like this (equity*0.0036/12).  This continues up to 0%

Can you please tell me why I can not add/change/modify data on a saved
worksheet?

I have created a VB function in a workbook and would like to use the same
function in other workbook (not worksheet). Ideally, I would like to copy it
somewhere in the workbook so I can refer to it as locally without referencing
other workbook. The application I have uses a ...

I am trying to create an if then statment where the value that is true is
automatically highlighted (shaded).

I'm an estimator who uses excel to enter data for jobs.  There are som
fields that will ALWAYS need to have something in them.  Is there a wa
that I can format these cells so that if I try and save before they ar
filled, I get an error?

I want to include a formula with a link name in a file template that will be
used by others.  The file name to be in the file name must vary each time a
new file is created and named from the template.  Each file includes the
person's name and a month year indication i.e. ...

OK here's the layout as best I can put it:
If A3 has a number less than 1040, then I want it to look at A4 to see if a
date is greater than or less than 12/31/03.
If A4 has a date later than 12/31/03, I want A3 to read "DC04", if A4 has a

How can I set up automatic sequential invoice numbering across multiple
worksheets but in the same workbood?  I have all my customers set up on
individual worksheets and would like to assign an invoice number when I
print.  Then would like the next time I print possibly a ...

What I want to do seems so simple but it's the only formula on thi
spreedsheet I can't figure out.  I've spent all day on it and it'
driving me nuts!  Here it is:
I want (cells not named so I'm using cell id's):  D5-G5.  If the resul

I need to have a formula similar to:
=LEFT(E52,70)
but I need to make sure that it does not break up word.  
IE...make a formula choose the word that is less than 70 characters long and

if i have 2 columns with different information in them how do i merge the
two to become one column with all the information in?
i'm trying to use vlookup to search a list of equipment (column B) and give
me the figure in the box next to it (column C) but some of the info i need

basically i want to do this equation
if a1=a3 than w
if not check to see if a1=b3 than x
if not check to see if a1=c3 than y

I import some data that gives me a date field that looks like this
"8/3/2005" in column A. I need a formula that will calculate how many days
are left until this field is 30 days old based on the date. This is an
invoice date and I have thirty days to file a claim for any ...