Below is my formula.  For this part of the statement:  IF(I5=2,E5/40*3, - I
need this to return a minimum number of 3 - can anyone tell me how to adjust
my existing formula to return 3 for this part of the formula (if it's result
is less than 3).  Thank you.

Hello!
I have worksheet "A" that includes various line items in which a formula
name may be duplicated.  I'd like to sum the formula name cost fields and put
it in worksheet "B".  I can't seem to figure this out, can anyone help me?

I'm using Excel 2007 on Windows XP. Is there any way to make the
scrolling not jump up and down an entire line at a time? I would like
to be able to scroll partially up or down a row, just a few pixels at
a time. I find the existing behavior difficult and frustrating to work

I have 2 Excel files with customer records.  Each file has a common customer
number and the other fields are different.  I would like to combine the data
into one file by using the common customer number to link the related records
from the 2 spreadsheets.

When I insert a row after I have recorded a macro, the macro stops referring
to the correct cells.  To fix this, I tried naming all the cells variables
and having the macro refer to the variable names instead of the cell location
(ie. A1).      

I had to step away from my desk in the middle of recording a new macro.  I
didn't want to lose my work so I stopped macro and saved.  
My question is, is it possible to start recording within the same macro from
where I left off?

when i open up a file...i have two worksheets in that file
one is :1 and the other is :2.
how do I get rid of one of these??
thanks,

I work at a service desk and I have a user that has forgotten their security
password to open an excel file.  I know you can run macros to reset the
password for a workbook or worksheet but can you do the same for a password
required to open the file?

Hello.  I am hoping someone can assist me.  In Excel 2003, I have a cell
where I
had created a data validation list.  I selected "List" in the Allow box, I
checked

Hi. I'm using Excel 2007 and all of a sudden this problem is happening...
I have a simple data table set up to calculate totals of columns.
I put the "SUM" function in the bottom row of column A and then drag it
across columns B-D to use the same function. What is happening is ...

Whenever you open a new Excel sheet, the macro security level is set to
"Medium" by default. How can I set to be "low" permanently?

What is the formula I would write to have a result be rounded up to
the enarest 1/8"?
Thanks,

I'm using Excel 2003.
For our baseball team I want to format a cell to calculate batting averages.
I want the calculated number to be a 3-digit number (such as .367) with NO
"0" before the decimal point...AND...if it calculates out to be something

information was imported into a program. The numbers  need to be converted to
currency. I am forgetting the route to take on this. trying the usual format
command obviously doesnot work.
Example 15208825 should be 152088.25

I have column A and Column B populated with dates.  Through a formula, In
column C,  i want to indicate "true" if the two dates are the same and
"false" if the two dates are different.