I have some really large and complicated IF statements (formula type, not
VBA) that I need to review.
I seem to recall a VBA tool someone created to do this, but I can't find a
link in my favorites.

i want to click on one cell in a worksheet and it take me to the other
worksheet cell on a different sheet. AND if there is currently nothing in
that cell i want it to be blank.
** what i'm trying to do is on one worksheet it tells you if certain things

i'm trying to use this formula =SUMIF(B1:B200,"<>sent",A1:A200)
if column C is one of 4 statements.  how do i use both?
for example, if column c is "A" then SUMIF(B1:B200,"<>sent",A1:A200)

I am using 2003 and counting colored blank cells.  The range is several rows
with some rows containing 4 column cells (ie A1, B1, C1, D1) and other rows
with only 2 column cells having merged A1 and B1 into one cell with C1 and D1
into a second merged cell.  

In the workbook I use for electric meter readings one of the months one row
doesn't calculate correctly. I cannot figure out why. The rest of the
workbook calculates the way it should. This particular row is about $45 off
what the total should be. Anyone know how I can fix this?

I need, if a1 is greater than b1 than print a1.  If b1 is greater than a1
than print b1. I haven't been able to find anything of any help in the help
screens.

First, thank you for your help.
I created a macro that is used with many different workbooks and I use the
worksheet name as criteria for one of the formulas. Is there a way to add
some code that will get the worksheet name of the open workbook and put it

I am trying to link values from a master list to seperate sheets, so that I
only have to edit the master list and all of my other sheets change
accrodingl.  I can do this but the only problem I am currently having is I
can't get it to recognize the formatting changes such as ...

Is there a way to use non contiguous cells with the slope function?
Specifically, if y's and x's contain non contiguous values.
SLOPE(known_y's,known_x's)
A simple example...

Hello!  I am trying to find out if there is a function in Excel which allows
you to do the following:
I have a list of approximately 50 numbers.  I need to fit these numbers into
a percentile range of 2% to 4% (to make it more understandable, I have a list

I am trying to keep the format of the original cell when I link it to another
workbook.  There are several employee names, one employee name per cell, all
cells are linked to another workbook.  One week the name john doe will be
changed to BOLD text in the original workbook, ...

What I would like to do is take the follwoing data:
INPUT TABLE
Inventory Tag    Item    Location    Qty
22                   H00016    770           20

I am trying to use OFFSET and MATCH to locate values in a unsorted table and
perform simple math with these values such as SUM.
When MATCH returns #N/A error value since what I am looking for does not
exist in the unsorted table, I would like the MATCH formula to return 0

I have an array which consists of some 100 variables but each can only be 1
or zero. (0.3 of a vehicle is meaningless!!!) If I place the constraints of

iterations with decimal numbers resulting in a long ...

I am creating a macro that will filter all of the rows of data in sheet 2
that have an x in a column, copy them, and insert them at the bottom of the
data set in sheet 1 - basically the first available blank row.
My problem is that when recording the macro when i go to sheet 1 to ...