there are bugs in microsoft exel 2007 for calculation of:
154,2 x 1700 = 262.140 if the result we divide by 4 equal to 100.000 and
then if we multiply again with 4 it's back to 262.140
and also if the result (262.140) we divide by 2 and than multiply again with

Hi
I'm using the following but shows as error yet if I only use a few it works
fine - what can I do to use all the cells I'm wanting? or should I be using a
completely different formula?

I have a series of coded billing amounts based on (a) whether a procedure is
in an office setting or a facility setting and (b) on how many minutes the
procedure takes.  I would like to be able to have Excel automatically enter
the amount of money expect to receive based on (a) ...

I am just starting with 2007. When seklecting, say. A1:a3,C1:C3 the 'shading
to show this is VERY indistinct.
Can I change the default colour so as to make this more obvious?
Thanks

I would like to ask if there is a way that I can add the same text to
existing text in all cells in column. Each cell has deferent text. I have
office XP.
Sol

"=Sheet2!B9"
I name my sheets to be the same value as the A collumn. It would help me if
I can replace "Sheet2" portion of the reference with a text from collumn A.
For example: If A1 has text "CARS," then B1 autamatically takes the value

Hi, I have 26 work books named week 1-week 26 each one has 7 sheets named
Sun- Sat and week, each sheet has a list of names in the first column and
data for each name in the next columns and it is all collated in the sheet
called week.

In Excel 2007 how do I format cells to show in the currency format (i.e.
$___.__)

i am creating a termly spreadsheet to calculate children,s point score.  If a
child joins us during the spring term I want it's score to be included in
that term but not in the earlier autumn term. I want therefore to disable the
formula in the autumn term calculation but let the ...

hi all i really need some help. the spreadsheet i have has hundreds of street
names on it and it list all the house numbers, so for example "high street"
will be on the spreadsheet 40 times then i'll have another 100 or more
streets with all the numbers displayed as well, when i ...

I have 330 sheets and need to delete the same columns on all of the sheets.  
How can I do this without clicking on each page?  Thanks!

how to switch off the dynamicaly linked themes ?
fi , one wants to use multiple themes in one sheet...

I have an array with 3 columns; (1) column A is labeled less than or equal to
and contains the lower range of values; (2) column B is labeled greater than
or equal to and contains the upper range of values; (3) column C is a
discrete value.  There are over 500 rows in my array in ...

I am creating an Equipment Status worksheet for my job. Is there a formula
that I can use to change the background color of a paticular cell if I type
the word of that paticular color in it? I.E. in the status column I type the
word "red" how can I make that cell's background ...