I have a workbook with formula's throughout.  If I put an input variable,
the formula would work. Now, if I change the number, other than 32, it blows
up, and I have "N/A" throughout the workbook where my formula are.  Is there
some format problem that I need to fix? It use to ...

How do i insert a Footer into an Excel Document?

I am trying to figure out if there is a non-macro function that I can
write for this scenario:
If A1 is greater than 10 and less than 50, return YES.
Here's what I had, but it always returns false:

In word this is referred to "any digit" and the text you use to find it is
"^#". Is there something similar in Excel?
Thanks!
Cynthia

In a payrol sheet I am adding a row of numbers calculating the amount paid in
one month.  There are 4 numbers all ending in 1.  the formula I used to
calculate is a very basic formula.  It is =SUM(G10:G14).  Instead of giving
me the last number as 4, it gives me a 5.

I need to subtract one cell from another and if the sum is 3000 or over, I
want the cell to be red. I need a function to do this. I'm a newbie so please
if you answer give me the complete function.
Thank you,

Hope someone can help with a macro. Want to highlight cells depending on
a value returned by a vlook up formula. If a value of 6 (could be
anything from 2 to 50) is returned in cell A100 (could be any column,
cell) then highlight the next 6 cells down or up depending on which row

I have two columns of similar looking data. Some of the values may match,
while the other may not. Is there a formula for me to find out the data in
one column that do not match with the data in the other

The following formula was given to me earlier on this forum and it works
great...thanks.
=SUMPRODUCT(--($A$1:$A4<A4),--($A$1:$A4>=A4-365),$B$1:$B4)
Now I need to understand how it works.  What is the signfigance of the --?

Need some help.
I have to extract multiple words from the string using VLookup function.
(Example :"Cell  A1 "This is the best example")
Example : Finding "This" from cell A1- result VLookup (Sheet1) A1:D12

I have been using Harlan Grove's PULL to reference values from a closed
workbook and it is very good for what it does.  But unfortunately it is not
too practical for referencing large data ranges, as calculations can take a
long time.

I have to create a form to use for inventory moves.  I want the form to have
a unique control number each time it is printed.  This way they can be signed
out and then signed in once the material handlers are done for the day.  This
way I can keep track if one is not turned back ...

I have a long column of NIC's MAC Addresses WITHOUT the dashes between every
2 characters. Need to know how to create an excel custom  format to make them
all have the dashes without manually putting in dashes.

Hi!  
Can someone please help me with this question regarding calculating the APR
that you see in the Federal Truth-In-Lending Disclosures when you sign a
contract for a car loan?

I am  adding a number to an existing formula on my workbook.  I have over
500 entires to update.  When I change the first formula and copy and paste
it, all the formulas become the same.  How would I be able to make each cells
formula the same and just add the one addition.