I am trying to calculate a commission % based on a gross profit % range.  So
I have 8 rows of % ranges with 3 columns, column 1 is greater than and column
2 is less than, the third column has the commission %.  Can someone tell me
how to have a formula look at the table and tell ...

I would like to use a picture as a background and edit cells over or under
it, I have set transparencies and used send to back options with no luck, I
prefer to avoid using the watermark option for lack of versatility.

I have one question concerning a Lookup function. Let suppose that we have
2 columns A and B. This function works fine and returnes a value from
column B which corresponds to a value from column A from the same row when
A value is EQUAL to my input (everything according to ...

I want to e-mail a workbook. In XP is was able to use File>SendTo...
In 2007, under Office Button>Send, all I see is Fax.
Is Sendto somewhere else in 2007, or do I have to install something to be
able to e-mail a file.

Hi, again
data displayed as follows
Column A  Column B Column D
1012          1013        1016

I receive reports weekly and I am creating a receipt log. When I receive the
report I enter the date I received it.
My date has to be setup as d-mmm-yyyy.
I create the year 2008 daily on another worksheet and name it Year2008.

Hello, maybe someone can see something obvious here.
I've got the following compare as part of a MATCH function, and it always
returns false. It doesn't seem to be stepping past the first row of the
column A. I am entering this as an array formula (ctrl-shift-enter). How come

Thanks for any help.
Is it possible to use the LARGE function in a non-continguous array? It
doesn't seem possible.
I got a couple arrays, all in the same column, but with rows in between them.

I have Excel 2003
Is there a way to only allow certain answers to be entered in a cell?
I only want them to be able to enter either Yes, No Or N/A (case doesn't
matter).

I need to dedupe within an excel spreadsheet. Example - every row that is the
same, I need to delete one.

I typed the following formula in and is displays the formula in the cell just
as it was typed in instead of calculating the formula.
=COUNTIF(C8:Q8,"=''")
Those are two single quotes after the equal sign.

I am trying to create a questionaire with drop down menus to choose different
answers. I have the drop down menu but I am not sure how to enter the text in
it that I want to give as answer options?

When clicking on the drop down arrow of a "List" validated cell, I have to
scroll up to see the contents of the list because only the blank area "below"
the list contents apears first.  How can I change the view to immediately
show the list contents starting from the first item ...

How do you have your spreadsheet automatically update the total amount when
changing values...
..example
amount ordered      price       total

Whenever I type (C) in Excel 2007, it defaults to the copyright symbol ©.  
How do I stop the program from doing this, and to allow me to choose when I
want to insert that or any other symbol instead of the program inserting it
by default?