Ok.. why is when I use the formule
=roundup(a1,02) is round up stuff like this?
226.9449 will become 226.95 ... how do I get it to be 226.94?

I am attempting to nest the and or functions.
I would like the argument to state:
IF C47 and D47 are negative... take the absolute value of g47/d47
IF C47 or D47 are negative.... take g47/c47+1

Quick question, Im taking in the values for a scatter plot and when
graphed My X axis is being labeled with row values.  
For example if I have 100 points lets say the first column is values
10,20...1000 and the 2nd column has 100,200...10000.  Now my first few

I should import a csv file with 70,000 rows into excel and then perform
an auto selection to get the required rows.
However, when I try to import the data, excel said that there are too
much data. What should I do in order to import all the data?

I have "inherited" a spreadsheet from someone else and am having
problem creating new formulas (there currently are no formulas in th
spreadsheet).  I don't know if there is an option setting causing th
problem or if it is something else.

I've put together a gas mileage spreadsheet.  It's real simple.  I enter a
row and it calculates the mileage.  The thing is, it gets it's beginning
odometer reading from the ending odometer reading of the previous entry.  And
rather than start at the top of the spreadsheet and ...

1. Open an Excel workbook with Sheet1 and Sheet2.
2. Would like Sheet2 to scroll to cell A1 upon the Event of
SheetDeactivate.
3. Background :Sheet1 contains hyperlinks leading to Sheet2 ; when a

How can I set my Excell so I can write and edit also inside the cells?
(Right now my Excell is set to edit in the window line after the "fx"
funntion on the top only)

I have a contacts list which is becoming quite large and I want to tidy
it up and make it easier to navigate. The list will be used by a number
of people who are on phones and who do not need the ability to edit the
list.

In the Microsft-VB Help file is described how to add a "temporary" men
item to a menu bar. However, the menu item does not disappear unti
Excel is closed whereas I want to get rid of it when closing th
workbook. Can anybody tell me how to achieve this?

Is there a way to insert a text cell from one page put into another page
and when the first page cell is updated the second page cell will also
be updated. Using the  = sign just displays the formula, not the text.

I need to have a choice/radio button in a cell, wherein the user can
just choose only one option instead of choosing from the drop down menu
that appears against a cell when data validation method is used.
Ex : User has to choose one of the 3 options shown in a cell.

Help!
I set up an import external database query (ms access) for an excel
report used on our network that works fine for me, but will not refresh
the data for anyone else.

is there a way to enter minute second data e.g., 30:43 without having to
enter the hour (none of the data points are over 59 minutes duration) ----  
i'm using the format [h]:mm:ss (since i want to add the values and the total
will exceed several hours) --- it seems to require an ...

is there a way to enter minute second data e.g., 30:43 without having to
enter the hour (none of the data points are over 59 minutes duration) ----  
i'm using the format [h]:mm:ss (since i want to add the values and the total
will exceed several hours) --- it seems to require an ...