I am trying to duplicat a paper form used in my work. It involves tracking
sales, adding them and calculating commissions. Let me try to put this
briefly. A customer may purchase ads in multiple books. My problem is
figuring out how to make the spreadsheet 1) determine that there ...

Forgive me for asking guidance on something which is probably quite simple.
I've set up a worksheet to calculate all the hidden costs of on-line
auctions and it is the PayPal aspect that is giving me grief.
PayPal charge me 3.4% + 20p per transaction. If I use:

OK guys, I have another problem I will post here and on another post if
nobody reads this.
I have the same 5 (A2:E2)fields, each with a 1 or 0. What I need this
time is that If A2 is 1, then I need A2 plus any 2 (1or true) of the

I have an excel spreadsheet that has 5 fields (cells-HIP, WAIST, ARM,
LEGS, HEAD) each with a value of 1 or 0 (True or False)
I need a formua to count the 5 fields and if there are 3/5 that are 1
(True) then fill a new cell (Total) with 1(True), if there are less

I don't know what's going on, but I have created a public subroutine in
my workbook, at the workbook level (not on a sheet) but none of my
sheets can see the subroutine.
I know this should be possible, I could swear I've done this for ages,

I am trying to build dynamic charts which chart only the series with
non-zero data in them.
i.e. I've got the chart pointed to a data range of say 20 different
series, of which only a handful are likely to have non-zero values in

Using Excel 97.
I know, Wow, but it does everything, for the most part, that I need.
Question:
I have a column of numbers; single and two digit.

All I want to do is type text into an excel worksheet cell. How do I do this
so that ithe line of text  stays within the cell and does not continue into
the columns to the right? It can't be that complicated!

I am trying to generate an average based on two criteria. I have column
A as the date that covers every day of a month, column B is colour (i.e.
blue, red, yellow, etc), and column C a number, column D is the total.
Every day column D updates automatically based on the date. I ...

After installing microsoft office 2003 I used it a few times, now when I go
into type a document I get a message at the bottom of the screen saying the
modification of the document is not allowed as it is locked. Please can
anyone help I am falling behind in my assignments. A ...

Running three independant PCs and laptop on microsoft workgroup network. Will
IRM work - what must I load to right protect a shared exel workbook?
(Workbook loaded on one computer and share with others ). Must I load onto
all 4 computers? Sorry I'm not as computer literate as ...

I need to create a cell entry that displays the name of the salesperson who
sold the most cars in the quarter. Use a combination of the “IF” and "MAX"
functions to do this. Hint: you will need to use these functions function
multiple times in the same formula to do this.

I wish to have Excel 2000 look along a row of letters and return the
highest letter/number (latest in the alphabet) to a cell.
the range is like: A-B-C1-D3
i can find the highest letter, but i can not find the highest number.

Help Please
I've built a spreadsheet for monthly rostas, with the columns;
Date, Day, Staff-a, Staff-b.
No problem with Date and created Drop-Down Lists for Staff-a, Staff -b.

How to set the amount of values visible when open a combo box?
and
How to have a default value highlighted when opened as always the top
of the list is visible.