Is there a way to write multiple formulas in one.
example:  I want change CHEVRON, INC.  to proper case and remove th
"," and replace it with a space.
Currently I have to write 2 formulas.  =proper(A1) then copy an

I want to activate a selected cell based on a test result.  For example
in a form I ask a Yes/No question.  If the answer is Yes I want th
next active cell to be (say) C62.  If the answer is No the next activ
cell should be (say) K103.

Is there a way to use sumif if you have two criteria?  More than two
criteria?
Thanks in advance.
Joe

I am trying to convert an old Louts 1-2-3 spreadsheet to Excel and am
having problems with one function - the Lotus @nsum function.
Ultimately what I need to do is be able to write a function that will,
beginning in row 2 sum every 5th row.

I'm trying to figure out a formula for the following.  I
have an order form where certain products are classified
as one of two categories.  THe two categories exist in a
combo box control (not userform or vba).  I want o add up

When opening borders on another version of Excel I had
the option of using a pencil and eraser.  Excel 2000 was
installed recently and I don't have this option.  I have
borders I can use but wish to be able to use the pencil

In each column I want to only be able to enter the same
value in two cells the have excel not allow that to be
typed in anymore. Furthermore can I use Data Validation to
change the two cells with the same value to Bold Type and

I need an urgent help to solve my problem.
I have a text field for bar code for items. It is as follows
3 04824 753512 8
I want it to be changed the same by removing the space in between and

I have a worksheet with a lot of vlookup's and calculations in it.  I would like to remove all error fields (such as #VALUE, or #N/A) at once without having to go in and delete each field.  Can this be done?

I havent been able to figure how to write "simple" formulas.... do i choose functions or do i just write the formula....
i need to subtract e4 and f4 from d4 then multiply by 40% for my total..
the other one i have is subtracting 2.95% + $.30 from d4
thanks so much for all the help

How do I delete Links that are no longer there?  When I
look at the Edit-Links, there are a number of referenced
files that no longer exist.  How do you delete these?

I have a large spreadsheet (30+ MB) which has lookups, if
statements, links etc.  So whenever I have it open, I set
calculation to manual, from the Tools>Options menu.
However, this affects any other spreadsheets I have open

I'm trying to find the average of a bunch of different cells. I only want the cells counted if they have a number in them. I don't want to count empty cells. I have unchecked the zero values checkbox in my preferences. I tried this formula =AVERAGE(c2+c5+c6+c8) but I get an error ...

I am trying to use the IF  function to return the value
of named cells (oldteamcost) or (newteamcost) depending
on the value in cell (b4) O or N (capital O or Capital N).
How do Get the function to look for the capital O or N

Row C:C contains # 1 - 15
Row D:D contains $ Amounts
In range C600 I want to count the number of cells in
column C with the # 1