Mac Forum / Applications / Excel / March 2006

I have an excel add-in which contains functions I need for work. These
functions are used in several workbooks which must be shared by several
users. All users have a copy of the add-in installed. Recently I
started using a mac (os X 10.3.9 office 2004) and the following error

thanks in advance for your help. I'm using this formula:
=IF(C4=1,"20",IF(C4=2,"15",IF(C4=3,"12",IF(C4=4,"10",IF(C4=5,"7",IF(C4=6,"5",IF(C4=7,"4",IF(C4=8,"3","0"))))))))
But when I add one more check, I get an error. For example, this gives
me an error:

Hi you all,
I'm posting here this message coz maybe some Excel-guru will give me the
solution. I moved from Excel under WinXP to the 2004 version under
Tiger. Everything is great. Compatibility works quite good (still got

I'm sure there's some easy way to do this but....
On most sheets of my workbook I have January-December listed down
column A with various expenditure types in columns B-E or whatever.
The last sheet I'm trying to prepare needs to reference various columns

Using Microsoft Excel X (at home) and 2004 (at work) I am trying to
copy rows of data from worksheets in one workbook to columns in
worksheets in another workbook while using the transpose and paste
values command under pastespecial. I tried to make a macro to do this

Please help!
Can I write a formula to get a cell on a worksheet to look at or get
information from a designated cell on the privious worksheet in the
same workbook.  ie. to add a number from January to a number in

In a column that validates from a list, typing an entry displays autofill data
rather than the list data. I have to click the selection arrows to show the
list or else turn of the autofill feature.
Is there a way to purge the stored autofill data from this column?

I currently have an excel-based bonus plan.  I would like to create a
macro that would request several inputs: gross sales, labor numbers,
service times, customer survey numbers, etc, and then use that data in
the existing spreadsheet.  My ultimate goal would be to create a macro

Is there any way to change the highlight color for an individual cell from
very pale blue to something easier to see?
Does anyone else find this a problem?
It drives me nuts. I use Office 2004 on my Mac for everything else, and

Using Excel 2004 for MAC OS X, I don't find a a toolbar button for
superscript and subscript under the Tools / Customize, like Excel for
Windows has?
Is there another way to get a "shortcut" to toggle the font to and from

I recently bought a new iMac Intel with 'Tiger' installed.
When I went to modify a spreadsheet that had operated quite
successfully under OS X 10.3.9 on my 'old' iMac, it behaved in peculiar
and frustrating ways.

Mac PowerBook G4, 2 GB RAM running Excel 2004
I copied a range of cells into a a new worksheet in a workbook. Now I've got
a mysterious link I don't want somewhere on the copied range. I cannot find
any external links in the copied cells -- they are all numbers and text, no

How to change my Mac exel so that it does not use dots as decimal
separator and commas as separator for thousands? I would require it to
be the other way a round. As you can imagine it is a litle annoying
when the excel does not understand the local way of handeling numbers.

Gang
I have a list in List Manager with all the bells & whistles visuals,
autofilters, total row.  I used to be able to hide specific rows (for
printing purposes), now it won't let me.  It says "cannot shift objects

The variable "sEscRate" is behaving as if it is declared Static in the
following subroutine & function. I'm puzzled why this is. Each invocation of
the function in the sub should be passing it the variable sEscRate with a
value of 0.05. I am expecting each time TestFunc will return ...