HI, I have to set up a formula to multiply only if the number is greater $100
by 0.60, The first $100 are not charge but bigger than that is $0.60 per each
hundred starting at 101, 201, 301, etc..Please help

Usign Excel 2000 on an XP box:
I have a client who wants to create a Pivot Table using a spreasheet with
approx. 1500 rows of data and 8 columns.  When she creates the Pivot Table,
she gets an error message saying that she is trying to add too many rows

I am working on a spreadsheet that as a column telephone numbers, however,
the '0' at the beginning of every number has been dropped.
How can I insert this so every number begins with a '0' ( the std's of the
numbers are from all over the UK so vary greatly)

I have a spreadsheet with over 650000 rows.  If I do a "Paste Special..." on
a column to convert from Formulas to Values it takes over 20 minutes!  Anyone
know how can I speed it up?  I'm surprised because it was so quick (< 5 secs)
to copy and paste the Formula over all the rows ...

Hi, I have 2 conditions in an IF formula and I am not familiar with the and
function but I would like to know how to link the 2 formula conditions in one
big formula.
The formulas I have are..

Hi folks, I wonder if you can answer a question for me - I want to insert an
email in to excel.  If someone clicks on the icon, it should open up the
email.  Please note that this email is going out to someone outside the
company so I don't think hyperlinks would work. Thanks. S.

how to sum for the last 12 month value
A1 - 100 : month (mmmyy)
b1 - 100 : my value
thanks

I have on one sheet a value in B2, that i want to find on another sheet in A
column and i want to sum all the values in the corresponding row.
Any help would be great, Thanks in advance.

I can do this in two steps using but i'm wanting to be a little more clever.
In a range i have a list of filenames.  I want to exclude in the count all
filenames that begin with PLAN.  I've tried using Countif(A2:A550,"<>PLAN*")
but it's not working!!  Any ideas how i could do ...

I have merged cells that need to wrap text. I used the VBA code several of
you provided and it is working great for the most part. The problem I am
running into is when I have more than one set of merged cells on the same
row. I have applied text wrap to each of them. Let's say I ...

Can anyone help?
In Excel 2000 you could click on Tools and in the Add Ins list set your
worksheets to Auto-Save every 10 minutes or so. I can't seem to find this in
Excel 2007 has it been removed and is there any new way of Auto saving?

I have an Excel table that lists over 500 boxes by product number,
description, usable space, and price. Is it possible to use calculated data
from another sheet to look up and provide the box products that match the
calculated usable space and display a list of the matching ...

I have the following categories
Monitor-CRT = asstype
17 inch = assdescr
1 = age

Hi, need some help.
I have 20 worksheets, with an additional sheet as the 'Summary' page. I have
a formula in cell A2 which returns the MAX value of the same cell in 20
worksheets (sandwiched between 'dummy' worksheets titled 'Start' and 'End').

Please help
I have tried all the formulas in the other post but none work. I either get
a circular error or shows #ref or #format.
My dates look like  03-JAN-98