I am looking for a rounding function that for a given set up number will
round each number to the nearest 5 increment. i.e. 1142.68,1268.05,1298.22 i
would like rounded to 1140,1270 and 1300. I tried the =round() function but
that just took off the decimals.

Hello    I'm trying to copy a chart from one worksheet to another.  Once I
copy the chart and try to change the source data   and I get the message "No
more fonts may be applied to this workbook"  After hitting Ok several times
the chart options windows appears. If I copy the ...

I'm having an issue with the following formula:
=IF(OR(I67>350, I67<600)),"LO","HI")
Basically if I67 is less than 350 I want it to say LO in the cell I'm
putting the formula in. If it's greater than 600 I want it to say HI. Thanks

I am the main person who creates a excel file for co-workers.  I have just
learned by this discussion group yesterday on how to protect certian things
in excel with passwords, and etc.
I go into my excel file daily and make changes.  I would like to know is

I have been trying to find a solution for this problem in the last 3
days.
I have a secured Access database. This db contains a Macro that i will
like to run from Excel. I need the code to run the Macro from Excel.

Good morning,
     I have an excel file that needs to be saved in 5.0 / 95 format and
every time i try to excel crashes.  I can save other files just like it with
no problem it is just this one specific file and its driving me crazy.  Is

Is there a way to not select a drive letter when creating pivot table in
Excel directly from an Access database? On the select database popup screen,
I cannot find a way to map it to the network \\ drive, instead only from a
letter drive. Thanks

Please go easy on me because I'm brand new to Excel.  I am trying to find a
way to 'select' a date to populate a cell rather than having to 'type' it in.
Is there a way I can use the Data Validation drop-down function to call up
an interactive calendar from which I can pick a ...

I have a spreadsheet full of IF statements linked to another sheet in an
excel document.  Unfortunately all the IF formulas will not update when the
condition is met.  When i attempt to check a formula, open the cell's formula
but don't change anything, then the formula updates.  ...

Ok i've read through a number of the sumproduct solutions to this type of
question but i'm still yet to find one that works in this case.
I have a worksheet that contains data about product rentals. To simplify the
example I have 3 columns as below for temporary fencing hire. One ...

I have an existing XLS file with a column that is currently manually
populated.  However, I would like to create a dropdown list for my end users
so they can choose a value from the dropdown list to populate this specific
field.  However, I can't seem to find how to go about ...

Given the range H5:S5, how can I have Excel return the cell address of
the first value that appears in that range.
=MATCH(1,--(H5:S5>0),0) entered as an array formula returns 4; this
value is in cell K5.  How can I get that cell address returned?

Days360 is coming up a few days short. This is what I have
      A        
1    today()
2    1/1/2010

I have a list that will have a reference number in column A from 1 to 2000
with additional information in column b and c.
so will be like
A       B       C       D

I have Office 2007 and would like to view my Excel toolbar in a "classic
view" (i.e. similar to Office 1997).  Thanks