software

I'm trying to make a worksheet and I need any number over 60 to be equal to
60. Or how can I make any negative number a zero? Please help, I've tried

Is there a formula that can match the end of the 4 quarters (March31,June
30,September30, and December 31) to todays date so I can initialize a report

In Excel 2003 how do you check two cell for the largest numnber, then
replace the existing one if true, without invoking the circular referance

I am working in a imported file that I can't change the format

hi all good people,
As I am a new excel user and don't know how to work with formulas.

Excel 2003.
I have a bar chart of several series. I wish to add a corresponding quot;goal

I want to be able to count the number of cells that have coloured text from a
range of cells. Is their a way to do this, I tried quot;countifquot; but was unable

When you type in 5/2, I know Excell will automatically convert it to 02-May.
I know I can change the formatting of the cell, up to even using a mask. How

If I'm using this formula...

i have a problem sharing read-write Excel files. i have networked 3
computers which need to share excel files. computer 1 uses excel 2002,

How can I Conditional format cells with a formula in them instead of a value.
I am using the Mid function to extract a text string to a column, then I

I'm trying to add the values in SHEET B column C2:C100 but only if they meet
two criterias. I want my answer in SHEET A colum h. In order to get a

I need to add insurance premiums to equipment loans, if selected by a
customer. We offer 3 kinds of insurance. Insurance inputs are in cells as

I would like to see the protect sheet option to extended so that you can
select multiple sheets in order to protect them.

'Found here..' (excelforum.com/showthread.php?t=521620)--

In column A I have group titles. In column B I have the individual
elements. So for example, the location in ColA is quot;Italyquot;, and then the

Would be great if some one could help. I have an inventory list which
would have over a 100 different products on it. These products are

My application requires a stacked colunm chart with series lines combined
with a minimum of three (3) data series represented as lines. Using the

I am trying to get a total monthly salary for employess in the row however
some of the cells could contain a variety of text, ex. laid off, vacation,

Hi all
i'v created macro with Keyboard Shortcut Ctrl b . now i want to change it to