I wanted to make a general comment about Excel for those of you that use the
spreadsheet to create journal entries for posting into your financial
systems. With all of the concern and new regulations making sure that the
financial statements of companies are correct, it seems relevant.

I use Excel to summarize daily reporting into a monthly journal entry,
actually several of them. I have found cases where the formulas in the cells
do not calculate the correct results, which would cause the journal entry to
be incorrect. The formulas range from simple "If" statements to "DSUM" and
"SUMIF" formulas. I have not been able to find a solution to the problem
within my spreadsheets. The only explanation I can come up with is that
Excel is not working correctly.

I take pride in my work and eliminate as much "human error" as I can. But
when I am using a spreadsheet that cannot produce accurate results, it
becomes a reflection on me, not on the software I am using. I don't think
there are many bosses out there that will accept the fact that software with
the Microsoft name on it will not work correctly.

If this problem is actually within Excel itself, then it seems to me that
Microsoft had better get its act together and clean up this software--and
quick. I wonder how Microsoft would like to have a company sue because they
produced inaccurate financials due to the fact that this spreadsheet software
cannot function as it is supposed to.

Examples?

Excel is not 100% perfect, but without specific examples I doubt if anyone
(especially your boss) will take this "Warning" seriously.

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"Paul" wrote in message
...
I wanted to make a general comment about Excel for those of you that use
the
spreadsheet to create journal entries for posting into your financial
systems. With all of the concern and new regulations making sure that the
financial statements of companies are correct, it seems relevant.

I use Excel to summarize daily reporting into a monthly journal entry,
actually several of them. I have found cases where the formulas in the
cells
do not calculate the correct results, which would cause the journal entry
to
be incorrect. The formulas range from simple "If" statements to "DSUM"
and
"SUMIF" formulas. I have not been able to find a solution to the problem
within my spreadsheets. The only explanation I can come up with is that
Excel is not working correctly.

I take pride in my work and eliminate as much "human error" as I can. But
when I am using a spreadsheet that cannot produce accurate results, it
becomes a reflection on me, not on the software I am using. I don't think
there are many bosses out there that will accept the fact that software
with
the Microsoft name on it will not work correctly.

If this problem is actually within Excel itself, then it seems to me that
Microsoft had better get its act together and clean up this software--and
quick. I wonder how Microsoft would like to have a company sue because
they
produced inaccurate financials due to the fact that this spreadsheet
software
cannot function as it is supposed to.

<I have found cases where the formulas in the cells do not calculate the
correct results

That is rather vague. Can you give examples?
Please give the cell addresses, the contents, the formulas, their location,
the expected result and what you got instead, the settings in
ToolsOptionsCalculation and any User Defined Functions.

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Paul" wrote in message
...
I wanted to make a general comment about Excel for those of you that use
the
spreadsheet to create journal entries for posting into your financial
systems. With all of the concern and new regulations making sure that the
financial statements of companies are correct, it seems relevant.

I use Excel to summarize daily reporting into a monthly journal entry,
actually several of them. I have found cases where the formulas in the
cells
do not calculate the correct results, which would cause the journal entry
to
be incorrect. The formulas range from simple "If" statements to "DSUM"
and
"SUMIF" formulas. I have not been able to find a solution to the problem
within my spreadsheets. The only explanation I can come up with is that
Excel is not working correctly.

I take pride in my work and eliminate as much "human error" as I can. But
when I am using a spreadsheet that cannot produce accurate results, it
becomes a reflection on me, not on the software I am using. I don't think
there are many bosses out there that will accept the fact that software
with
the Microsoft name on it will not work correctly.

If this problem is actually within Excel itself, then it seems to me that
Microsoft had better get its act together and clean up this software--and
quick. I wonder how Microsoft would like to have a company sue because
they
produced inaccurate financials due to the fact that this spreadsheet
software
cannot function as it is supposed to.

<I have found cases where the formulas in the cells do not calculate the
correct results

That is rather vague. Can you give examples?
Please give the cell addresses, the contents, the formulas, their location,
the expected result and what you got instead, the settings in
ToolsOptionsCalculation and any User Defined Functions.

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Paul" wrote in message
...
I wanted to make a general comment about Excel for those of you that use
the
spreadsheet to create journal entries for posting into your financial
systems. With all of the concern and new regulations making sure that the
financial statements of companies are correct, it seems relevant.

I use Excel to summarize daily reporting into a monthly journal entry,
actually several of them. I have found cases where the formulas in the
cells
do not calculate the correct results, which would cause the journal entry
to
be incorrect. The formulas range from simple "If" statements to "DSUM"
and
"SUMIF" formulas. I have not been able to find a solution to the problem
within my spreadsheets. The only explanation I can come up with is that
Excel is not working correctly.

I take pride in my work and eliminate as much "human error" as I can. But
when I am using a spreadsheet that cannot produce accurate results, it
becomes a reflection on me, not on the software I am using. I don't think
there are many bosses out there that will accept the fact that software
with
the Microsoft name on it will not work correctly.

If this problem is actually within Excel itself, then it seems to me that
Microsoft had better get its act together and clean up this software--and
quick. I wonder how Microsoft would like to have a company sue because
they
produced inaccurate financials due to the fact that this spreadsheet
software
cannot function as it is supposed to.

Sorry about this one

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Niek Otten" wrote in message
...
<I have found cases where the formulas in the cells do not calculate the
correct results

That is rather vague. Can you give examples?
Please give the cell addresses, the contents, the formulas, their
location,
the expected result and what you got instead, the settings in
ToolsOptionsCalculation and any User Defined Functions.

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Paul" wrote in message
...
I wanted to make a general comment about Excel for those of you that use
the
spreadsheet to create journal entries for posting into your financial
systems. With all of the concern and new regulations making sure that
the
financial statements of companies are correct, it seems relevant.

I use Excel to summarize daily reporting into a monthly journal entry,
actually several of them. I have found cases where the formulas in the
cells
do not calculate the correct results, which would cause the journal entry
to
be incorrect. The formulas range from simple "If" statements to "DSUM"
and
"SUMIF" formulas. I have not been able to find a solution to the problem
within my spreadsheets. The only explanation I can come up with is that
Excel is not working correctly.

I take pride in my work and eliminate as much "human error" as I can.
But
when I am using a spreadsheet that cannot produce accurate results, it
becomes a reflection on me, not on the software I am using. I don't
think
there are many bosses out there that will accept the fact that software
with
the Microsoft name on it will not work correctly.

If this problem is actually within Excel itself, then it seems to me that
Microsoft had better get its act together and clean up this software--and
quick. I wonder how Microsoft would like to have a company sue because
they
produced inaccurate financials due to the fact that this spreadsheet
software
cannot function as it is supposed to.

Paul wrote...
....
I use Excel to summarize daily reporting into a monthly journal entry,
actually several of them. I have found cases where the formulas in the cells
do not calculate the correct results, which would cause the journal entry to
be incorrect. The formulas range from simple "If" statements to "DSUM" and
"SUMIF" formulas. I have not been able to find a solution to the problem
within my spreadsheets. The only explanation I can come up with is that
Excel is not working correctly.
....

Despite what you may believe, the odds are that any incorrect results
in your spreadsheets are the result of your own errors rather than
errors in Excel's internal functionality. There are exceptions, e.g.,
many of Excel's stats functions produce poor results for extreme (and
sometimes not so extreme) values, but for the most part Excel produces
the results it should given the restrictions on numeric precision.

If you're having problems with IF, SUMIF and DSUM, the problem is
likely either due to boolean comparison semantics you've misunderstood
or you have formulas that haven't been but need to be entered as array
formulas.

Without details it's impossible to diagnose your problem formulas.

Paul,
It sound like you need to ALWAYS wrap the Round() function around all your
DSums and IF statements.
HTH,
--
Gary Brown

If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"Paul" wrote:

I wanted to make a general comment about Excel for those of you that use the
spreadsheet to create journal entries for posting into your financial
systems. With all of the concern and new regulations making sure that the
financial statements of companies are correct, it seems relevant.

I use Excel to summarize daily reporting into a monthly journal entry,
actually several of them. I have found cases where the formulas in the cells
do not calculate the correct results, which would cause the journal entry to
be incorrect. The formulas range from simple "If" statements to "DSUM" and
"SUMIF" formulas. I have not been able to find a solution to the problem
within my spreadsheets. The only explanation I can come up with is that
Excel is not working correctly.

I take pride in my work and eliminate as much "human error" as I can. But
when I am using a spreadsheet that cannot produce accurate results, it
becomes a reflection on me, not on the software I am using. I don't think
there are many bosses out there that will accept the fact that software with
the Microsoft name on it will not work correctly.

If this problem is actually within Excel itself, then it seems to me that
Microsoft had better get its act together and clean up this software--and
quick. I wonder how Microsoft would like to have a company sue because they
produced inaccurate financials due to the fact that this spreadsheet software
cannot function as it is supposed to.