I am wondering if anyone can help me with the following statement.
I have a number (example 1.068501) which i need to round up to 3
decimal places or 4 significant figures if the number is greater than 1
so the result would be 1.069.

how to predefine an english word ie. "S" on the cell. So, user each
time
just type in ie. 1243 and the cell will return S1243. Then the user no
need to type so many times of "S" in front of 1243. If the user ie.

Office 2003...XP
I am using a basic "equals to" conditional format and I wish to know how to
give resulting  text size of my choice, but it is text size "greyed out" in
the way I have it in condition 1 format.

I had weeknum function in one of my documents but it doesn't work anymore.
It's not even in a list of functions. :-0
How do I fix this, to get my week numbers back?
BR

I am using an Excel based invoice and I want to add a serial number that will
automatically update each time I open a new invoice. Is there an easy way?
Thanks

I need to display the four top sales and reference the name of the sheet the
information came from in the cell beside it.  I can get the largest number,
but from there all I get is errors.  Any help?

I have setup a column with a list box that includes several project headings.
I have also setup a list box that allows you to select the amount of time you
spend on each project. The worksheet has 30 rows that will allow you to
select the project and time, what formula can I use ...

I have a list of about 14 numbers in each row, and I need a formula that
calculates the highest number out of a specified set eg. =max(c2, e2, g2,
j2). The problem is that some lines require two cells to have this formula
and when I do that it creates a circular reference. How ...

Is there a way to delete cells if they are already listed on a separate
spreadsheet?
For example, I have two list of names (list A & B)
List A                              List  B

I have 4 workbooks (for 4 weeks having details on 4 different people), which
need to be consolidated into one at the end of the month. Each of these
workbooks have details which are grouped thus:
Week 1 workbook.xls

I am tring to view a woek schedule but for some odd reason the system won't
let me how do I open it

Ok, I am having a problem with the vlookup.  In the first column I am
trying to looking a the numbers like 18 78 would give me the results
from the 18 90 line below, that is what I want.  But my problem is
trying to get the results to match the 18 100 line results.  It will

Could anyone tell me how to find the greatest common factor in excel, and is
there a built in function in excel that could find it directly.

excel 2003 or 2007 beta 2
How can I get the diagonal of a matrix returned as a single column vector?

I need to add another condition to my formula.
=$B15-(SUMIF($I$53:$I$533,$C15,$H$53:$H$533))
The formula I'm using is works now I need each line to look at Column
and If it equals F15 then do the formula and conditions below.