You know microsoft excel can do math calculations. adding, multiplying, dividing and subtracting.

Try this calculation if you have excel 2007
850*77.1. See what you get.

Then do the exact same calculation using a calculator, or even the calculator that COMES with WINDOWS!

It seems that microsoft has forgotten how to multiply! (or maybe its coding works screwed up)

This is a by now well known bug in Excel 2007.

I'm guessing what happened here is that there's an off-by-1 error in a comparison somewhere (i.e. ">= 65535" instead of "> 65535"), and the 32-bit quotient/remainder print routine kicks in. Since the number is already smaller than 100000, it PROBABLY hits a fall-thru case where the quotient is assumed to be 1, and there's no remainder, hence it is printing 100000.



yeah, i know, i was wondering what the problem was.So decimal #s confuse Excel?Quote from: Comp Guy on September 30, 2007, 04:56:47 PM

So decimal #s confuse Excel?

This is a by now well known bug in Excel 2007.

Microsoft know this?

hm...i found lot of people talking "microsoft have bugs more than apple"

Quote from: kuszmania9999 on October 03, 2007, 01:14:13 AM

hm...i found lot of people talking "microsoft have bugs more than apple"

If 90% of the population is running Windows and 10% running MAC products how many Windows problems will you hear about compared to MAC problems ? ?
Do the math.
Every OS / program has it's issues...