I have array formulas in a worksheet. But some cells throw up error
value's such as div!/0 etc. i want to hide these errors but somehow am
not able to type the right function using iserror(cel_ref). Can anybody
tell me how to use ISERROR with array formulas

I am creating a worksheet. In it, one cell has a drop-down to select 1 of 9
values.
Once one of these nine values is selected, I want other cells to
auto-populate from other information within the worksheet.

I am trying to format dates in a spreadsheet. These dates are in a mixed
format. They change to a five digit format (for e.g. 06/03/2005 is represnted
by a five digit no. - 38417). I am unable to sort the date because it is not
in the correct format even if I change it to date. Is ...

Every time I open a spreadsheet I get three workbooks opened.
One is the one I clicked on, another is called "book1"and the other
is called "personal [read only]".
I use a networked pc at work.

HI
New user to this forum and after some help on my attached file.
I want to assign a points scoring system to my sales staff.
In column E i have the sales person's average units per sale. I have a

I have a csv created from external application.  When opened and saved as
.xls the c/r within each cell display and print as a box. I am guessing it
differs from the excel alt return, which does not display.  Is there a way
to replace the erroneous char so a box is not displayed?

What formula can I use to determine the Annual Percentage Yield (APY) for a
Certificate of Deposit.  The interest rate is 5.10% anually with the
interest added back daily.  The bank told me that the interest rate is 5.10%
and that would be 5.20% APY.  How would they know what the ...

I've got data in columns separated by two other columns. I wish to
create a formula in another column that will include the data from
these two non-sequential columns. How do I do this?
Ex: data are found in columns G(rows 1) and J(rows1) and would like to

HI
When I have my regional settings at Canada (French) and I open a CSV file it
does not
See the commas as column separators

I want to a macro to display the name of the button (or object) from where I
am calling that macro. Anyone an idea?
thanks,
Derek

I have a filled series of numbers that are relative. How do I change them to
absolute?

Okay - this is really tough for me to explain but I have a code for my
macro that I have an error on and I CANNOT figure out why!  I am not
too good at explaining this so please ask any questions on info you
may need!!!  Thank you so much in advance!!!  Here is my code - please

Hi I want to create a macro to allow users to enter data using data form.
Having set up my worksheet I have selected column headings.  I then sedlect
Data > Form, at which point I get an annoying message up saying that Excel
doesn't kn ow which rows to use as headings.  I can ...

Compare B1 and C1 and you put in A1 the greater value. :confused:

If i have a total dollar amount owed monthly of $215.17. But my company pays,
for $131.28 and the remainder is paid by me of $83.90. How do i find out the
total percentage that is paid by my company? In formulars for excel?